DDE Functions
Connector DDE links use the same protocol to communicate with the Working Papers database in both Word and Excel, but the syntax of the DDE functions differs. To view the formulas in Excel and Word, click Alt + F9.
Function | Arguments | Example |
---|---|---|
act() |
|
Returns the report balance for account 101. |
class() |
|
Returns the report balance for trade receivables in current assets. |
clp() |
|
Returns the operating name of the client. |
cvdata() |
|
Information located in the CaseView Database. More information on use of the CV Database may be found in the CaseView Help. |
desc() |
|
![]()
Returns the selected description for account 101. |
entdesc() |
|
Returns the short description for the entity entered in the Entity Properties dialog of the consolidated file. |
field() |
|
Returns the Signed off User (A1) for Document 2.00 from the Document Manager database (SH). |
grp() |
|
Returns the balance for a given group number/ID combination based on the specified balance type. The example would retrieve the report balance for Group 1's grouping AA. |
grpdesc |
|
Returns the group description for a specified group number/ID. |
map |
|
Returns a balance for a given map number based on the specified balance type |
mapdesc |
|
Returns a description for a specified map number. |
sdate(field()) |
|
Returns a date value from a specific field in a database. The example would search the Document Manager (SH) database to retrieve the Role 1 Sign Off Date (AD1) for the document numbered 7.2. |
tax |
|
Returns a balance for a given tax code based on the specified balance type. |
taxdesc |
|
Returns tax code description for a specified tax code. |
ud() |
|
The value associated with a User Defined Data code. Values are entered under Tools | User Defined Data in CaseView. |