You are here: Help Topics > Practice > CaseWare Connector > DDE functions

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 differ.

Function Arguments Example
act()

balance_type

account_number

The Microsoft Excel worksheet icon as displayed in the Document Manager cwin32|Data!'CWEval|active|act("BR","101")|'

The Microsoft Word document icon as displayed in the Document Manager { DDE CWIN32 Data CWEval|active|act(\"BR\",\"101\")| \* MERGEFORMAT }

Returns the report balance for account 101.

class()

balance_type

class_id

client_file

The Microsoft Excel worksheet icon as displayed in the Document Manager cwin32|Data!'CWEval|active|class("BR","TR")|'

The Microsoft Word document icon as displayed in the Document Manager { DDE CWIN32 Data CWEval|active|class(\"BR\",\"TR\")| \* MERGEFORMAT }

Returns the report balance for trade receivables in current assets.

clp()

clp_code

client_file

The Microsoft Excel worksheet icon as displayed in the Document Manager cwin32|Data!'CWEval|active|clp("CLP2")|'

The Microsoft Word document icon as displayed in the Document Manager { DDE CWIN32 Data CWEval|active|clp2| \*Charformat \* MERGEFORMAT }

Returns the operating name of the client.

cvdata()

group

form

id

client_file

The Microsoft Excel worksheet icon as displayed in the Document Manager cwin32|Data!'CWEval|active|cvdatal("GROUP2","FORM2","ID2")|'

The Microsoft Word document icon as displayed in the Document Manager { DDE CWIN32 Data CWEval|active|cvdata|(\"GROUP2\",\"FORM2\",\"ID2\")| \*Charformat \* MERGEFORMAT }

Returns information located in the CaseView Database. More information on use of the CV Database may be found in the CaseView help.

desc()

account_number

client_file

The Microsoft Excel worksheet icon as displayed in the Document Manager cwin32|Data!'CWEval|active|desc("101")|'

The Microsoft Word document icon as displayed in the Document Manager { DDE CWIN32 Data CWEval|active|desc(\"101\")| \*Charformat \* MERGEFORMAT }

Returns the selected description for account 101.

entdesc()

entity_id

client_file

The Microsoft Excel worksheet icon as displayed in the Document Manager cwin32|Data!'CWEval|active|entdesc("E1")|'

The Microsoft Word document icon as displayed in the Document Manager { DDE CWIN32 Data CWEval|active|entdesc(\"E1\")| \*Charformat \* MERGEFORMAT }

Returns the short description for the entity entered in the Entity Properties dialog of the consolidated file.

field()

database_identifier

column_heading

row_identifier

client_file

The Microsoft Excel worksheet icon as displayed in the Document Manager cwin32|Data!'CWEval|active|field("SH","A1","2.00")|'

The Microsoft Word document icon as displayed in the Document Manager { DDE CWIN32 Data CWEval|active|field(\"SH\",\"A1\",\"2.00\")| \*Charformat \ * MERGEFORMAT }

Returns the Signed off User (A1) for Document 2.00 from the Document Manager database (SH).

grp()

group_number

balance_type

group_id

client_file

The Microsoft Excel worksheet icon as displayed in the Document Manager cwin32|Data!'CWEval|active|grp("1","BR","AA")|'

The Microsoft Word document icon as displayed in the Document Manager { DDE CWIN32 Data CWEval|active|grp(\"1\",\"BR\",\"AA\")| \* MERGEFORMAT }

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()

group_number

group_id

client_file

The Microsoft Excel worksheet icon as displayed in the Document Manager cwin32|Data!'CWEval|active|grpdesc("1","AA")|'

The Microsoft Word document icon as displayed in the Document Manager { DDE CWIN32 Data CWEval|active|grpdesc(\"1\",\"AA\") | \*Charformat \* MERGEFORMAT}

Returns the group description for a specified group number/ID.

map()

balance_type

map_number

client_file

The Microsoft Excel worksheet icon as displayed in the Document Manager cwin32|Data!'CWEval|active|map("BR","511")|'

The Microsoft Word document icon as displayed in the Document Manager { DDE CWIN32 Data CWEval|active|map(\"BR\",\"511\")| \* MERGEFORMAT }

Returns a balance for a given map number based on the specified balance type.

mapdesc()

map_number

client_file

The Microsoft Excel worksheet icon as displayed in the Document Manager cwin32|Data!'CWEval|active|mapdesc("511")|'

The Microsoft Word document icon as displayed in the Document Manager { DDE CWIN32 Data CWEval|active|mapdesc(\"511\",\"0\")| \*Charformat \* MERGEFORMAT }

Returns a description for a specified map number.

sdate(field())

database_identifier

column_heading

row_identifier

client_file

The Microsoft Excel worksheet icon as displayed in the Document Manager cwin32|Data!'CWEval|active|sdate(field("SH","AD1","7. 2"))|'

The Microsoft Word document icon as displayed in the Document Manager { DDE CWIN32 Data CWEval|active|sdate(field(\"SH\",\"AD1\",\"7.\2\"))| \* MERGEFORMAT }

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()

balance_type

tax_export_code

client_file

The Microsoft Excel worksheet icon as displayed in the Document Manager cwin32|Data!'CWEval|active|tax("BR","10.D")|'

The Microsoft Word document icon as displayed in the Document Manager { DDE CWIN32 Data CWEval|active|tax(\"BR\",\"10.D\") | \* MERGEFORMAT }

Returns a balance for a given tax code based on the specified balance type.

taxdesc()

tax_export_code

client_file

The Microsoft Excel worksheet icon as displayed in the Document Manager cwin32|Data!'CWEval|active|taxdesc("06")|'

The Microsoft Word document icon as displayed in the Document Manager { DDE CWIN32 Data CWEval|active|taxdesc(\"06\") | \*Charformat \* MERGEFORMAT }

Returns tax code description for a specified tax code.

ud()

user_defined

client_file

The Microsoft Excel worksheet icon as displayed in the Document Manager cwin32|Data!'CWEval|active|ud("UD1")|'

The Microsoft Word document icon as displayed in the Document Manager { DDE CWIN32 Data CWEval|active|ud1| \*Charformat \* MERGEFORMAT }

Returns the value associated with a user defined data code. Values are entered under Tools | User Defined Data in CaseView.