hello all, can you help a newbie please , I have a access database , the main form has a subform, I am trying to get on the click of a button the subform to be saved as an excel worksheet I know I can do this through a macro but what I am trying to achieve is this.
on the mainform I have a text box I wold like to save the excel workbook under the name of the value in the textbox .
example the text box is called drawing,and contains the value "one" (value can change), so when I save the subform as a worksheet it will be called "drawing one". is this possible ? if so what is the vba code to do this please.
thanks in advance
on the mainform I have a text box I wold like to save the excel workbook under the name of the value in the textbox .
example the text box is called drawing,and contains the value "one" (value can change), so when I save the subform as a worksheet it will be called "drawing one". is this possible ? if so what is the vba code to do this please.
thanks in advance