Description

Closes Microsoft Excel workbook previously opened in an established Excel session. If modifications have been made, the document will be saved. (To close and save a Microsoft Excel document that was modified with prior Automated Workflow Excel steps.)  If this action is not used, the document will not be saved.

IMPORTANT: The Excel actions in Automated Workflow use the Microsoft Excel automation engine to perform their work, because of this Microsoft Excel must be licensed and installed on the system to use the Excel Actions.

Declaration

<AMEXCELCLOSEWORKBOOK SESSIONNAME="text" SAVE="yes/no">

Example

<AMEXCELCREATEWORKBOOK WORKBOOK="c:\myexceldocument.xls"><AMEXCELSETCELL NEWVALUE="Set this data here" CELLROW="1" CELLCOLUMN="1"><AMEXCELSETCELL NEWVALUE="and this here" CELLROW="2" CELLCOLUMN="1"><AMEXCELCLOSEWORKBOOK>

General Tab Parameters

Session name: Specifies the session name to identify which document should be closed from prior Excel steps. This allows several Excel files to be open simultaneously. If working with only one document, this value should not be changed from its default value.

Text, Optional - Default "Default"
MARKUP: SESSION="YES"

Do not save changes: When enabled (selected), specifies that the document should be closed, but not saved. The default behavior (cleared) is to save the document when it is closed.

Yes/No, Optional - Default YES
MARKUP:
a) SAVE="no"

See Also

Create Workbook, Open Workbook,  Add Worksheet, Activate Worksheet, Get Cell, Set Cell, Cells to Dataset, Dataset to Cells