Importing a tab within a spreadsheet utilizing the TransferSpreadsheet Action

R

rmorrison

How do I specify a specific tab to import within an Excel
spreadsheet utilizing the TransferSpreadsheet action
within a macro? It seems to only utilize the first tab
within the spreadsheet.
 
J

Jim/Chris

Pass the name of the sheet with ! appended as the Range
argument of
TransferSpreadsheet, e.g.
"Sheet2!"

Jim
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top