Is it possible to use transferspreadsheet with excel worksheet index? I would like to use index(1) in place of Sheet1.
Code:.TransferSpreadsheet acImport, 10, "foo_table", Application.CurrentProject.Path & "\Data Pulls\foo_worksheet.xls", True, "Sheet1!A1:H"