Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cannot save excel files to a folder on a network | Excel Discussion (Misc queries) | |||
macro save a workbook whilst increasing file no | Excel Worksheet Functions | |||
Save as Msg box | Excel Discussion (Misc queries) | |||
Save as Msg box | Excel Discussion (Misc queries) | |||
Save & Save As features in file menu of Excel | Excel Discussion (Misc queries) |