transferspreadsheet using excel workbbook index

[xopherira]

Is it possible to use transferspreadsheet with excel worksheet index? I would like to use index(1) in place of Sheet1.

.TransferSpreadsheet acImport, 10, "foo_table", Application.CurrentProject.Path & "\Data Pulls\foo_worksheet.xls", True, "Sheet1!A1:H"

[Micron]

I think you will have to use automation to open the file (can be in the background) and get the name of Sheet(1). Access doesn't seem to like a reference to the worksheet index e.g. Sheets(1) in the DoCmd syntax.