Identify last active cell in excel worksheet

  • Thread starter Thread starter Jeannie
  • Start date Start date
J

Jeannie

I need to insert several workbooks into an Access data table. Is there a
way, from within Access, using VBA to identify the last active cell in each
of the Excel workbooks?

I'm a novice in the coding world
Thanks!
 
Jeannie

You and I may not have the same definition of "last active cell".

Have you looked into using a link to the Excel workbook(s) instead of
importing the data?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Jeannie,
as far as I know, when you import data from an excel worksheet into an
access table, the default is to import all the active cells in the workbook.
This incules all the cells you would select if you opened the worksheet, put
the cursor in the top and left most cell, then did Ctl + End. It can include
all cells with formulas or formats set that do not have any actual text in
them.

Jeanette Cunningham
 
Back
Top