Save As Macro Help

  • Thread starter Thread starter Tyson
  • Start date Start date
T

Tyson

I'm trying to get my head around this but my Macro experience is nada.

I found the following code while searching for info on how to do this.

Sub SaveAsToday()
ActiveWorkbook.SaveAs FileName:=Format(Now(), "dd-mm-yy")
End Sub
From what I can tell it will make the Save dialog use the current date
Click to expand...
as the name for the file.

I need CurrentDate-PartList.xlt as the name and redirect it to
"C:\2005-PartsOrders\"

Thanks

Tyson
 
Sub SaveAsToday()
Dim myFileName as string

myFileName = "C:\2005-PartsOrders\" & Format(Date, "dd-mm-yy")
ActiveWorkbook.SaveAs FileName:=myfilename
End Sub

But this actually just saves the file as that name. Did you really want to see
the File|SaveAs dialog?
 
Back
Top