cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
GroupSquareWolf
Level III

Scripting: open all sheets from an Excel file

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

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Scripting: open all sheets from an Excel file

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.

View solution in original post

1 REPLY 1

Re: Scripting: open all sheets from an Excel file

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.