Can I save a file named ( yesterdays date ) using a macro.

Try...
ActiveWorkbook.SaveAs Filename:="C:\Documents and Settings\username\My
Documents\" & Format(Now() - 1, "yymmdd") & ".xls"

Frank

"sd" wrote:

Can I save a file named ( yesterdays date ) using a macro.

Hi SD,

Try something like:

'=============
Sub aTester()
Dim strPath As String

'// CHANGE path to suit
strPath = "C:\Documents and Settings\" & _
"YOUR USERNAME\My Documents"

'// Or, to save to the default folder:
'strpath=application.DefaultFilePath

ActiveWorkbook.SaveAs _
Filename:=strPath _
& "\" & Format(Date - 1, "YYYYMMDD") & ".xls", _
FileFormat:=xlWorkbookNormal

End Sub
'<<=============


---
Regards,
Norman



"sd" wrote in message
oups.com...
Can I save a file named ( yesterdays date ) using a macro.