I am using the following line of code from withing access
to import from excel:

DoCmd.TransferSpreadsheet acImport, 8, Me![NewTableName],
Me![DirName], True, Me![SheetRangeName]

Me![DirName] = the file path
Me![SheetRangeName] = A named range that the user has to
enter manually.

How can I substitute the "Me![SheetRangeName]" for
whatever populated range in excel automatically?

-----Original Message-----
possibly

set rng = xlapp.ActiveSheet.Range("A1").currentRegion

--
Regards,
Tom Ogilvy

"Al" wrote in message
...
How can I determine the start and the end of populated
cells in excel from a form in access. I am using access
97.
thank you
Al


.