Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Increment File Name by 1
I have 52 files, one for each week of the year, and one blank master. When
a change is required the master is updated then the files are over written for the weeks to come, this is done manually one file at a time. The file names are RC1 WK1 RC1 WK2 etc Is it possible to save the blank master as RC1 WK? to RC1 WK52, ? being the first file to start from, over writing the previous files? Thanks Blue |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Increment File Name by 1
doing from memory, so syntax might not be perfect but...
Private CommandButton1_Click ( dim dim pathofsavefile as strin pathofsavefile = "C:\temp\RC1 WK x = 1 application.displayalerts = fals Do Until x 5 ActiveWorkbook.SaveAs Filename:=pathofsavefile & x = x + Loo Application.DisplayAlerts = Tru End Su |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Increment File Name by 1
doing from memory, so syntax might not be perfect but...
Private CommandButton1_Click ( dim dim pathofsavefile as strin pathofsavefile = "C:\temp\RC1 WK x = 1 application.displayalerts = fals Do Until x 5 ActiveWorkbook.SaveAs Filename:=pathofsavefile & x = x + Loo Application.DisplayAlerts = Tru End Su |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Increment File Name by 1
A bit late but thanks for the info blue -- Soltisolti ------------------------------------------------------------------------ Soltisolti's Profile: http://www.excelforum.com/member.php...o&userid=15118 View this thread: http://www.excelforum.com/showthread...hreadid=349182 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Increment by 18 | Excel Worksheet Functions | |||
Increment | Excel Worksheet Functions | |||
increment a value by 1 | New Users to Excel | |||
need to increment value | Excel Discussion (Misc queries) | |||
Help with increment problem please | Excel Programming |