Exporting to an existing Excel worksheet

V

Vinny

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
 
K

Klatuu

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