nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

552088_en-US

liliconcom

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>,</WORKSHEETS>

Thanks

Scripting

Comments

There are no comments yet

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Help
Best Of