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.
 
Back
Top