I have an Excel file that I need to save-as automatically to a static
location of my choosing at 12Noon, 5:00pm & 11:59pm every day the file is
used, which is every day. When save-as occurs at these times, I need the file
to save with a name like "MyFile_todaysdate_1200.xls" or
"MyFile_todaysdate_1700.xls" or "MyFile_todaysdate_2359.xls". I know a file
can not use "/" in the filename so the date can look like 061808.
I just have not been able to peice this together with what little I know
along with posts I've read. I really appreciate any assistance with this.