Exporting to an existing Excel worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to go into Access, use a form to enter data, and then export
only that record to Excel and add it to the bottom of an existing Excel
spreadshet? I would like to do it with a macro if at all possible. I don't
know programming at all.

Thank you in advance!

Vinny
 
Not with a Macro. You will have to use automation open the Excel workbook as
an Excel object, determine the last row that has data, then enter the data in
the next row. Sorry, but it is just too complex for a Macro to handle.
 
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

How to Export Gmail Emails to PST Format? 4
Export to Excel causes field name issue 1
Export Report to a Worksheet 1
Exporting separate query results to same workbook diff worksheets 2
Exporting to Excel 2007 1
Exporting query to a Excel workbook 1
Export to excel with pictures????? 1
the best way to export 600K records 2

Back
Top