I would like to import spreadsheet worksheets into Access by stepping through existing tabs.
for i = 1 to 20
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, _
"tbl_Temp" & i, pathFileName, True, Worksheet ! i
The tab names are not stable enough to hard code the tab names. I would like to go to 1, 2, 3, etc. I would also like to extract the names of these tabs, if possible. If all else fails I will just open the spreadsheet using the excel object and work my way around that.
I can not get to my email until after 8:30 PM eastern time. Because of restrictions at my J. O. B.
Thanks in advance!