Syntax

ExportExcel(FileName [, SheetIndex][, FirstRow][, FirstCol][, FileFormat][, Password][, WriteResPassword][, ReadOnlyRecommended][, CreateBackup][, AccessMode][, AddToMru][, UseExcelLanguage])

Return value

None

Parameter

Use

Name

Type

Passing

Description

Required

FileName

String

ByVal

Name of the Excel file. If this file does not exist a new file is created

Optional

SheetIndex

Long

ByVal

Index of the sheet in the Workbook Standard is 1

Optional

FirstRow

Long

ByVal

The line number from which the data is to be entered into the sheet
Standard is 1

Optional

FirstCol

Long

ByVal

The column number from which the data is to be entered into the sheet
Standard is 1

Optional

FileFormat

Long

ByVal

The Workbook format
    XLF_CSV = 6&

    XLF_XLS_12 = 50&

    XLF_HTML = 44&

    XLF_XLSX = 51&

    XLF_XLSX_MacroEnabled = 52&

    XLF_XLS_8 = 56&

Optional

Password

String

ByVal

A case-sensitive string (not more than 15 characters) that specifies the protection password to pass to thefile.

Optional

WriteResPassword

String

ByVal

A string that specifies the read-only password for this file. If a file with the password is saved and the password is not provided when the file is opened the file is opened as read-only.

Optional

ReadOnlyRecommended

Boolean

ByVal

True to display a message when you open the file that recommends that the file should be opened as read-only.

Optional

CreateBackup

Boolean

ByVal

True to create a backup file.

Optional

AccessMode

Boolean

ByVal

The access mode for the workbook.
    XLSAM_Exclusive = 3

    XLSAM_NoChange = 1

    XLSAM_Shared = 2

Optional

AddToMRU

Boolean

ByVal

True to add this workbook to the list of recently used files. The default value is False.

Optional

UseExcelLanguage

Boolean

ByVal

True stores files with the language of Microsoft Excel (including Control Panel settings). False (default) stores files in the language of Visual Basic for Applications (VBA) (which is usually English (U.S.), unless the VBA project running Workbooks.Open is an old internationalized XL5/95 VBA project).