Scripting: open all sheets from an Excel file

GroupSquareWolf — Fri, 09 Jun 2023 15:59:36 GMT

What is the syntax to open all sheets from an excel file without naming all the sheets?

This is the script log I got after clicking "Select all" in Excel Wizard. The specific excel file had 2 sheets name "Sheet1" and "Sheet2".

Worksheets( {"Sheet1", "Sheet2"} ),

I could not find help from Scripting Index either

Open( excelFilePath,
     <Worksheets( "sheet name" | {"sheet name", "sheet name", ...} | "n" )>,

Thanks

Re: Scripting: open all sheets from an Excel file

Mark_Bailey — Mon, 03 Oct 2022 17:50:10 GMT

This simple syntax should work:

dt = Open( "Path\Workbook Name.xlsx" );

The variable dt will store a list of data table references when there is more than one sheet.