Hello.
I have a spreadsheet that people need to load, [statstemplate.xls], which asks for there first name [A1] and last name [A2] of the person and basically they fill in the data, then click new work [macro], which creates a new work line for them, but i need it to save with the following info:
I need the [statstemplate.xls] to change to datefirstname_lastname.xls
so it would look like this 30052010joebloggs.xls
Also what i need as well is for it to create a folder for eg [ c:\stats\ ]upon the first time they use the template, and if there is already a folder named that, that it doesnt say there is, it just autosaves in there.
Then every 5 minutes it auto saves in there.
So basically upon running the first macro it
a) creates a new folder
b) doesnt ask to create it, or say there is already a folder there
c) saves the statestemplate.xls as datefirstname_lastname.xls
d) autosaves every 5 minutes.
Thanks
Bookmarks