Excel TransferSpreadhseet question.

[DaveO]

I'm trying to link an Excel spreadsheet to the database I'm working on
(access 97).

There are 12 worksheets in the Excel workbook and I wish to reference a
sheet called Committed & Invoices, which is sheet12.

I cannot, for love nor money, get this to work.

Here are the things I've tried in the range box:

Committed & Invoices! - error os it think the ! is a $.
Committed & Invoices - object not found.
Committed & Invoices$ - object not found.

Can anyone help at all please?

TIA.

 

[jleckrone]

Committed & Invoices! should work. Make sure that you have the name
correct. I tested this and it worked using the ! after the name. I
did the transfer using a macro and not DoCmd.TransferSpreadsheet.

 

[jleckrone]

Committed & Invoices! should work. Make sure that you have the name
correct. I tested this and it worked using the ! after the name. I
did the transfer using a macro and not DoCmd.TransferSpreadsheet.

 

[jleckrone]

Committed & Invoices! should work. Make sure that you have the name
correct. I tested this and it worked using the ! after the name. I
did the transfer using a macro and not DoCmd.TransferSpreadsheet.