Specify named range for transferspreadsheet method

  • Thread starter Thread starter Shaggles
  • Start date Start date
S

Shaggles

I am trying to automate linking a 2 worksheet Excel
spreadsheet using the DoCmd.TransferSpreadsheet method but
I don't know how to reference the second worksheet. I
tried this but I got the error message "'Sheet1' object
was not found" (or something like that.) Can anyone tell
me the correct way to reference individual worksheets
within an Excel workbook? Thanks.
 
You must log in or register to reply here.

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

Similar Threads

Excel Multiple Worksheets - TransferSpreadsheet VBA 0
Excel VBA 1
Syntax for TransferSpreadsheet method 4
TransferSpreadSheet Question 1
How to reference a cell from anther workbook without opening it 0
TransferSpreadheet: Importing a Specific Spreadsheet 3
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
output to, transferspreadsheet, or excel automation? 2

Back
Top