Is there a way that i can tell it is working.
Also in this piece of code i want to name the file 1 hour less than the current Now hour. I tried to change the now to a now-1 that didn't work. Do you know how to do that as well
ActiveSheet.SaveAs Filename:="\\nas01\SBC\Team Leaders\TL Shared Info\Reports\HourlyReports\" & "TAG Hourly SL " & Format(Now , "mm_dd_yy hAM/PM") & ".xls"