ExcelSave

Structure

ExcelSave(sFileName)

Type

Procedure

Description

This function saves the an Excel file in memory.

Parameters: 1

sFileName = The full name (including path) of the file to save.

Example

Try

ExcelNewFile(3,"v2003")

ShowMessage(ExcelGetSheetCount) 'shows 3

ExcelSave("C:\Temp\TextExcel.xlsx") 'Attempts to save the file

Except

ShowMessage(LastExceptionMessage) 'would display "Invalid file format" if an invalid choice is used for the second parameter

End Try