I am setting up reports to run each night, around 25 of them. This will create a file called trace.log. I am able to rename the file without issue. However I need the file name to be a date and time stamp.
I have seen this done in excel, but I am wondering if I can accomplish this thru the VBA code itself. Eventually, I will have the report named as "Location&Date&time.xls" Any ideas or fingers pointed in the right direction is greatly appreciated.Code:Name "C:\Program Files\Ericom Software\PowerTerm\trace.log" As "C:\Test1.xls"