TranserSpreadsheet

[jfredel via AccessMonster.com]

I am trying to link an Excel worksheet to an Access DB using a macro which
uses the TransferSpreadsheet command. Everything works fine but now there
are multiple worksheets in my Excel file. My question - in the macro how do
I tell it which worksheet to Link? The file name is C:\Rework Data.xls and
the worksheet name I need is Receipts.

Thanks in advance for the assistance,
Jeff

 

[Ken Snell [MVP]]

Use the Range argument of the macro action:

Receipts$

 

[jfredel via AccessMonster.com]

Just what I was looking for, thanks.

Use the Range argument of the macro action:

Receipts$

I am trying to link an Excel worksheet to an Access DB using a macro which
uses the TransferSpreadsheet command. Everything works fine but now there

[quoted text clipped - 6 lines]

Thanks in advance for the assistance,
Jeff