Exporting to Specific Excel Worksheet

[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.

 

[Nikos Yannacopoulos]

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