DoCmd.TransferSpreadsheet

[Nirious]

I have aproblem with the range of this thing. I think I have a wrong synthax or something.

I need to have the first 120 records of columns A and D
The first two lines aren't records but titles

So I had:

DoCmd.TransferSpreadsheet acLink, acSpreadsheetTypeExcel8, "ExcelTEMP", mijnFile, False, "A3:A122;D3:D122"

Access tels me there is somthing wrong with the range, though it works in Excel

 

[kalmeida]

Correct it to this:

DoCmd.TransferSpreadsheet acLink, acSpreadsheetTypeExcel8, "ExcelTEMP", mijnFile, False, "A3122" <-----

 

[Mile-O]

kalmeida means "A3122" but has just forgotten to turn off smilies.

Of course, given that it was nine years ago, I'm not sure it matters any more.