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