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.
 
Back
Top