I have excel file with multiple tabs - 4 tabs total. I'm attempting to upload the various excel tabs into access with a macro ""TransferSpreadsheet". I have 4 "TransferSpreadsheet" actions for the 4 tabs. I've been able to transfer the first spreadsheet in access with the "TransferSpreadsheet" macro. The following "TransferSpreadsheet" do not work. The problem seems to be they all seem to be refering to the first tab (which I assuming is the default tab).
In the Action Agrument - "file name", how does one distingush the various tabs in excel with in the same excel file.
example:
Upload.xls has four tabs : "rates";"provider";"location";"equipment"
All four have the "file name":
file name:C:\Documents and Settings\name\Desktop\upload.xls
In the Action Agrument - "file name", how does one distingush the various tabs in excel with in the same excel file.
example:
Upload.xls has four tabs : "rates";"provider";"location";"equipment"
All four have the "file name":
file name:C:\Documents and Settings\name\Desktop\upload.xls
