Populated cells

A

Al

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
 
A

Al

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?
 
Top