ExcelOpen

Structure

ExcelOpen(sFileName)

Type

Procedure

Description

This function attempts to open an Excel file.

Parameters: 1

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

Example

Try

ExcelOpen("C:\Temp\TestExcel.xlsx")

ShowMessage(ExcelGetSheetCount)

Except

ShowMessage(LastExceptionMessage) 'would display an error message from Windows if the file doesn't exist or cannot be opened.

End Try