COPY2XLS

Used in a JUSTAFTER to export fields from a report into an Excel file.

Reporting Area(s)

General

Required Parameters

None

Optional Parameters

1. Character return string: specified fields to export. IMPORTANT: fields listed MUST be in report cursor.
2. Character return string: path/name of file. If none is specified, an Open dialog opens for you to select the place to save the file/enter the file name.
3. Character string to set type of export file. Defaults to 'XLS'. Other options are: 'CSV', 'FOXPLUS', 'SDF', 'DELI', 'XLSX', and 'XML'.

Example(s)

JUSTAFTER("COPY2XLS()") - exports all fields to an Excel file and allows you to select location of saved file/enter file name.

JUSTAFTER("COPY2XLS('nmname1,nmname3,nmemail')") - exports first name, last name, and email address to an Excel file and allows you to select location of saved file/enter file name.

JUSTAFTER("COPY2XLS(,'c:\acehold\emails.xls')") - exports all fields to an Excel file named emails.xls into the c:\acehold folder.

JUSTAFTER("COPY2XLS(,,'CSV')") - exports all fields to an CSV file and allows you to select location of saved file/enter file name.

Related Functions

CAT2XLS
JUSTAFTER