TransferSpreadsheet - Multiple worksheets

F

FBxiii

Hi.

I am trying to link to a spreadsheet using DoCmd.TransferSpreadsheet
acLink....

The spreadsheet has multiple worksheets, how do I modify the command to the
link to another worksheet instead of the first? I have tried playing with
the Range parameter, but can't get it working.

Can anyone help?
 

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