TransferSpreadsheet - Multiple worksheets

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

 

[Alex Dybenko]

Hi,
this works for me:

docmd.TransferSpreadsheet
acLink,acSpreadsheetTypeExcel9,"MyTable","C:\MyFile.xls",,"MySheetName$"

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[FBxiii]

It works for me to!!

Thanks,
Steve.

Hi,
this works for me:

docmd.TransferSpreadsheet
acLink,acSpreadsheetTypeExcel9,"MyTable","C:\MyFile.xls",,"MySheetName$"

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com





.