shanesuzanne
New Member
- Joined
- Dec 1, 2016
- Messages
- 21
Table name is employees
File name is varFile (used with a file picker)
This works:
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12, "employees", varFile, False, "January!A4:AD10000"
The problem is the tab names change each month. For the life of me, I can't get the sheet codename to work. This is sheet(1). I've googled for HOURS. Can anyone point me in the right direction?
The code is in Access 2010, importing from Excel 2013. Thanks!
File name is varFile (used with a file picker)
This works:
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12, "employees", varFile, False, "January!A4:AD10000"
The problem is the tab names change each month. For the life of me, I can't get the sheet codename to work. This is sheet(1). I've googled for HOURS. Can anyone point me in the right direction?
The code is in Access 2010, importing from Excel 2013. Thanks!
Last edited: