Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
On a monthly basis, I need to save a lot of templates, located in different
folders. The locations of each folder has a folder named UPDATED located in the same directory. Furthermore, I need to have UPDATED added to the end of each file name. This is what I've come up with so far: ActiveWorkbook.SaveAs "..\UPDATED\" & FILENAME & " UPDATED.xls" This saves the file in the correct place, but only as "UPDATED.xls". Is there a function that I can put in the place of FILENAME that will reference what ever file is currently active, in a way that allows me to add UPDATED to the end of it? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
howto: saveas with file name from a cell in the current worksheet | New Users to Excel | |||
howto: saveas with file name from a cell in the current worksheet | New Users to Excel | |||
workbook saveas function, xlText file format | Excel Programming | |||
changing current directory to that of the current open file | Excel Programming | |||
overwrite Excel SaveAs function from File menu | Excel Programming |