Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Save file with todays date ref#11235
Hello,
I need to save an excel file to the below directory with todays date can anyone assist me in combining the two formulas. Formulas to save file as todays date ActiveWorkbook.SaveAs "Report" & Format(Now, "yyyymmdd") & ".xls" This is the directory Sub test3() ' ' test3 Macro ' Macro recorded 1/29/2009 by ME ' ' ActiveWorkbook.SaveAs Filename:= _ "\\Wnccteav4\CCVOL4\MFC\SHARED\GSAM\Macro Database\Currency Imbalance\Imbalance database\For 01.30.09.xls" _ , FileFormat:=xlNormal, Password:="", WriteResPassword:="", _ ReadOnlyRecommended:=False, CreateBackup:=False End Sub |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Save file with todays date ref#11235
Construct your file name string first like this
FName="\\Wnccteav4\CCVOL4\MFC\SHARED\GSAM\Macro Database\Currency Imbalance\Imbalance database\Report" & Format(Now, "yyyymmdd") & ".xls" Then use it in the Save line ActiveWorkbook.SaveAs Filename:= _ FName, FileFormat:=xlNormal, Password:="", WriteResPassword:="", _ ReadOnlyRecommended:=False, CreateBackup:=False " wrote: Hello, I need to save an excel file to the below directory with todays date can anyone assist me in combining the two formulas. Formulas to save file as todays date ActiveWorkbook.SaveAs "Report" & Format(Now, "yyyymmdd") & ".xls" This is the directory Sub test3() ' ' test3 Macro ' Macro recorded 1/29/2009 by ME ' ' ActiveWorkbook.SaveAs Filename:= _ "\\Wnccteav4\CCVOL4\MFC\SHARED\GSAM\Macro Database\Currency Imbalance\Imbalance database\For 01.30.09.xls" _ , FileFormat:=xlNormal, Password:="", WriteResPassword:="", _ ReadOnlyRecommended:=False, CreateBackup:=False End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Recovering File Info Specifically Save Date or Print Date | Excel Discussion (Misc queries) | |||
Saveing workbook to a file as todays date daily | Excel Worksheet Functions | |||
Create a button that will date stamp todays date in a cell | Excel Discussion (Misc queries) | |||
When I open my past invoice it keeps changing date to todays date | Excel Worksheet Functions | |||
Automatic Populate Todays Date in Cell when File is Saved. | Excel Discussion (Misc queries) |