I got a nice one to solve.
In a spreadsheet I made a form to be filled in by a user. After he filled in the form, he clicks on a button, assigned to a macro. The macro then prints out the form. This, off course, is not a hard thing to make.
What I want to achieve, is to save the file with a filename referred to a value in a cell, or even better, referred to two cells. This has to happen the same time when somebody uses the button to print the form. In this way, the user does not know that the file he prints, is secretly saved as well.
For example:
A1 ==> Date + Time ==> 05-06-08 16:44
A2 == > Username ==> John
A3-A10 ==> input
When John is done filling cells A3-A10, he clicks on the button which runs the macro to print the form and to save the form in the background with this generated name:
05-06-08 16:44 John.xls
Who can help me with this problem? I already read somewhere it can be done using VBA, but I want to know if there is a way without using VBA.
Yours faithfully,
Falakka
In a spreadsheet I made a form to be filled in by a user. After he filled in the form, he clicks on a button, assigned to a macro. The macro then prints out the form. This, off course, is not a hard thing to make.
What I want to achieve, is to save the file with a filename referred to a value in a cell, or even better, referred to two cells. This has to happen the same time when somebody uses the button to print the form. In this way, the user does not know that the file he prints, is secretly saved as well.
For example:
A1 ==> Date + Time ==> 05-06-08 16:44
A2 == > Username ==> John
A3-A10 ==> input
When John is done filling cells A3-A10, he clicks on the button which runs the macro to print the form and to save the form in the background with this generated name:
05-06-08 16:44 John.xls
Who can help me with this problem? I already read somewhere it can be done using VBA, but I want to know if there is a way without using VBA.
Yours faithfully,
Falakka