DoCmd.TransferSpreadsheet Range Argument

[RunTime91]

Greetings All!



I'm working with Access front end built many years ago in which the range argument for a DoCmd.TransferSpreadsheet is as follows:

SheetName & "$"

The full query is here

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12, "WorkbookName", FilePathName, True, SheetName & "$"

I'm sure the: "$" is a variable is some sort but what does it represent? Entire sheet? Current Range? Special Cells?
The code works perfectly but I'm doing some mods to the program and would like to know what the heck it represents?

Thanks so much

Rt91

[CJ_London]

in the context of excel the $ marks the end of the sheet name, so it is not a variable.

So a range in sheet1 might be

sheet1$A1:C333

sheet1$ on its own means the whole sheet - not because of the $, but because there is nothing after the $

[RunTime91]

Ahhh...Ajax - Thank You! That explains it perfectly!!

Stay Tuned for another interesting couple lines of code from this very old db

Thanks again!