Macros to save as "" in a specific location?

I've created a spreadsheet which multiple users will be using, but at the end of the week I want it to save in a specific folder called for arguments sake "c:\shared\archives" but on "reset" sheet in the work book I have WEEKNUM in B11 which I want it to SAVE AS (this will save as just a number I'm guessing, so if i can somehow get "WK" in there somehow... even better)

I will also have a button which I have recorded, to clear down user inputs on certain sheets, would it be possible to do both on the same button? and if so, I'm guessing the "SAVING part would have to be first in line?)

I have only started using Macros within the last hour, so I am new to this.

And just out of curiosity, could this be done automatically at a certain time of day, or when next logged on after that day/time???? but doing this, may save again when viewing through archives so I'll have duplicates? (I try to learn as much as I can )


Many Thanks

One more thing!

Just thought... If it's possible to Save As and wipe data, would it be possible to then Save the current work book when wiped so it will...... SAVE AS WK"" ..... WIPE "" cells then save?

I've managed to get it to "save as" in a certain location, but the filename saves with the name the folder it is saved in, PLUS what ever is A1 which I Wanted to save as originally? e.g "newfolderbook1"

Here is the code.

Please Login or Register  to view this content.

Any Ideas?