DADiSP Worksheet Functions > Function Categories > ActiveX > Automation Client > XLSAVE

 

XLSAVE

Purpose:

Saves the current Excel Workbook via ActiveX Automation.

Syntax:

XLSAVE( verbose)

verbose

-

Optional. An integer, the message flag

0:

do not display Excel messages (default)

1:

display Excel messages

Returns:

A 1 if successful, else an error.

Example:

xlinit("C:\temp\myfile.xls");

xlput("A1:C10", ravel(1..30, 10));

xlsave();

xlclear();

 

The file C:\temp\myfile.xls is opened and the values 1..30 are shaped into a 10x3 array and written to cells A1 through C10. The Workbook is saved to the original file C:\temp\myfile.xls.

Remarks:

XLSAVE connects to the running instance of Excel.

 

See XLSAVEAS to save to a specified file in an optional format.

See Also:

XLCLEAR

XLGET

XLINIT

XLPUT

XLSAVEAS