Exporting to Specific Excel Worksheet

  • Thread starter Thread starter Alex Richardson
  • Start date Start date
A

Alex Richardson

Am using Transfer Spreadsheet command in a macro to update
an Excel spreadsheet. I can get it to work if I update a
spreadsheet with only one worksheet, but I can't figure
out how to update a specific worksheet in a spreadsheet
containing multiple worksheets.
 
Alex,

One of the arguments of TransferSpreadsheet is Range; use it to specify a
worksheet name, it will be created if it does not exist, or overwritten if
it does.

HTH,
Nikos
 
Back
Top