Importing a tab within a spreadsheet utilizing the TransferSpreadsheet Action

  • Thread starter Thread starter rmorrison
  • Start date Start date
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.
 
Pass the name of the sheet with ! appended as the Range
argument of
TransferSpreadsheet, e.g.
"Sheet2!"

Jim
 
Back
Top