Save as: sequences?
 

Hello -

I've created an Excel template which is linked to files that update
weekly -- the responsible person simply goes into the template, clicks
a button and the data updates. These files need to be saved
historically (for future reference), file name format like this:
X://Server/Folder/Data_wkYYww.xls
where YYww is the year_week the data is from.

I'd like to create a macro/button which will go to the correct folder
and automatically update using the proper week. For example, if the
data is for wk0627, the macro would save the name as:
X://Server/Folder/Data_wk0627.xls
without the user typing anything at all.

Is this possible? I've tried several times (mainly calc'ing the YYww
value in the file and the pasting it into the file name) but with no
luck.

All help is appreciated....

Rgds, Ray