Hi I'm trying to create a macro to Save a Document to a specifi
location. I also need to to add the Date to the files name.
Example:
Supervisors report - run macro and saves it to
c:\Supervisors report\supervisors report 18 Nov 2004
Same thing next day:
c:\Supervisors report\supervisors report 19 Nov 2004
All run from a Read Only master called Supervisors report
Thanks in advanc
--
Message posted from http://www.ExcelForum.com
Conder - 19 Nov 2004 15:58 GMT
Cracked it:
ActiveDocument.SaveAs FileName:="c:\test\test1 " & Format(Date
"dd-mm-yyyy"
--
Message posted from http://www.ExcelForum.com