ExcelNewFile

Structure

ExcelNewFile(iSheets,sFileFormat)

Type

Procedure

Description

This function creates a new Excel file in memory.

Parameters: 2

iSheets=# of sheets to create, by default.

sFileFormat = the Excel version to create. Options are:

"v2003"

"v2007"

"v2010"

"v2013"

"v2016"

"v2019"

Example

Try

ExcelNewFile(3,"v2003")

ShowMessage(ExcelGetSheetCount) 'shows 3

Except

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

End Try