Hi,
I'm using the following macro to save a workbook file;
Public Sub SaveAsD63()
ThisFile = Range("D63").Value
ActiveWorkbook.SaveAs Filename:=ThisFile
End Sub
1. How can this be modified to add the current date, (DD/MM/YYYY) to the filename,
2.How can i save the file to the current directory
Thanks in advance for your help
I'm using the following macro to save a workbook file;
Public Sub SaveAsD63()
ThisFile = Range("D63").Value
ActiveWorkbook.SaveAs Filename:=ThisFile
End Sub
1. How can this be modified to add the current date, (DD/MM/YYYY) to the filename,
2.How can i save the file to the current directory
Thanks in advance for your help