How to properly set the Range in TransferSpreadsheet (1 Viewer)

TURabbIT

Registered User.
Local time
Today, 13:23
Joined
Sep 9, 2014
Messages
10
Hey all,

I need some help with the DoCmd.TransferSpreadsheet Range parameter.

I want to import from an xls-File just the second page, titled "Härte". How do tell this the compiler?

Code is:

DoCmd.TransferSpreadsheet acLink, acSpreadsheetTypeExcel8, "Härte", file, True, "Härte"
 
Last edited:

TURabbIT

Registered User.
Local time
Today, 13:23
Joined
Sep 9, 2014
Messages
10
Okay got it! :D

It needs n "!".

DoCmd.TransferSpreadsheet acLink, acSpreadsheetTypeExcel8, "Härte", file, True, "Härte!"
 

Users who are viewing this thread

Top Bottom