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