form and subform to excel

bigmac

Registered User.
Local time
Today, 12:46
Joined
Oct 5, 2008
Messages
302
hello all, can you help with my problem please,
I have a form with subform that I wish to save as an excel spreadsheet, I can save the subform via a macro , but what I am trying tp archive is this .
1. on the form [mainform]I have several text boxes [client name], [drawing name] and [project name]these I would like to on the spreadsheet in particular fields on the spreadsheet please see attached sample .
2. below this a would like to have the subform, as I say I can export the subform but not with the mainform textboxes .
3. last thing , I want this to save the name of the spreadsheet as the same name as the drawing textbox (that is if it contains "drawing one" then the spread sheet would be called "drawing one" ).
I think this will have to be in VBA , if so can you show me how to do this please, thank you :confused:
 

Attachments

  • test.jpg
    test.jpg
    72 KB · Views: 210

Users who are viewing this thread

Back
Top Bottom