Populated cells

  • Thread starter Thread starter Al
  • Start date Start date
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
 
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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Conditional listbox cell populating 4
Extract data from XML file and populate them into cells 1
formattig word paragraphs from excel 5
Macro to select, set, and print 12
Sumproduct to populate 0 if cell is blank 2
Stubborn array wont change destination worksheet - HELP! (reposteddue to incorrect formatting) 2
Array to specific worksheet - nothing seems to work 2

Back
Top