Hi
I have a template Excel form that many users have access to
They are meant to use saveas after completing the form, but often forget and the template is populate and frustrates the next user
Can anyone provide the vb code for a Save button
The code would need to create the file name from a cell reference on the sheet and then add the date saved on it. The target of the folder also needs to be included.
For example the file name is based on a customer's reference code that has 10 digits, a example file name would be
1234567890 - 221205
This needs to be saved in the C drive in a folder called Manual work / 2006
Any help is appreciated
Thanks
I have a template Excel form that many users have access to
They are meant to use saveas after completing the form, but often forget and the template is populate and frustrates the next user
Can anyone provide the vb code for a Save button
The code would need to create the file name from a cell reference on the sheet and then add the date saved on it. The target of the folder also needs to be included.
For example the file name is based on a customer's reference code that has 10 digits, a example file name would be
1234567890 - 221205
This needs to be saved in the C drive in a folder called Manual work / 2006
Any help is appreciated
Thanks