Save As macro

[Jaan]

How I can Save As.
Macro opening every night file(file name sample "info") and updating
information( 4 linking file)
I need solution, how today file "info" save as "info18.09.2004.xsl.", but
tomorrow same file "info" save as "info19.09.2004.xsl." automaticaly.Can
some help me

 

[Don]

Hi Jaan,

This might work for you,

Sub Save_Workbook()
'Next line if you don't want to be bothered by alerts
'Take it out if want the automatic alerts
Application.DisplayAlerts = False
ActiveWorkbook.SaveAs Filename:= _
"C:\**name of folder to save in**\**sub-folder**\" & _
"info" & Format(Date, "mm.dd.yy") & ".xls", _
FileFormat:=xlNormal, Password:="",WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False
'Next line resets alerts if you've disabled them above
Application.DisplayAlerts = True
End Sub

HTH,

Don