Create and export data from form to excel

C

Chad

Hello, I have a form named frmMain and it has a subform named frmMainSubform.
On this subform I have a few controls. I would like to add a button on my
frmMain that would generate an excel workbook and in the first rows like A1
and B1 and C1 have the same headings as what I have on my form and with the
information from my form. How would I do this? Thanks!
 
J

Jeanette Cunningham

Chad,
on the button you can use Transfer Spreadsheet.
vba help tells you how to set up the code.


Jeanette Cunningham -- Melbourne Victoria Australia
 
Top