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