Skip to main content

ExcelSave

Structure

ExcelSave(sFileName)

Type

Procedure

Description

This function saves the an Excel file in memory.

Parameters

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