DoCmd.TransferSpreadsheet

[Beginner613]

Hi All!
I want to use
"DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "ImportSpecification", "FileName", True"

and it does work. But what should I add in the code in order to specify TAB in my excel spreadsheet. This excel spreadsheet has 10 different tubs. I want specific one...


Thank you in advance,
B

 

[PHV]

Add the named range as 6th parameter.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Beginner613]

Can u please clearify?

 

[traingamer]

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, strTable, FileName.Path, True, [b]"SheetName!"[/b]

where SheetName is the name of your sheet (tab)

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[Beginner613]

THANK YOU!!!