ImportExportSpreadsheet Macro

[Dundee Lad]

Hi Board, I am using access 2013. I am trying to get the ImportExportSpreadsheet Macro to import one of the sheets in a work book. The sheet tab name changes but will always be 'Sheet2'. Do you know what I input into the range field to import this?

 

[mole999]

That sounds right to me, but I don't know and can't test it

what is the file connection string you have in its entirety

DoCmd.TransferSpreadsheet acImport, 10, "Tbl_Costs2", "Q:\Production Database\Tables\Tbl_Costs\2016_17 YTD.xlsx", True, "P1 Capex!"

 

[xenou]

AFAIK you cannot use anything but an actual sheet name (tab name) with the TransferSpreadsheet() function. You will have to use Excel automation to get the sheet name if all you know is its CodeName.