Hi, you asked:

Unfortunately it is scheduled to run at 5pm Saturday. So it is quite
probable that the file will need to be edited around that time on
workdays.
So, will this work?

Tom's suggestion should work for you. Here is my take on what Tom
suggested, "then you could also check the day of the week":

If WeekdayName(Weekday(Now)) = "Saturday" _
And Time TimeValue("5:00 PM") Then
'Run the report
Else
'Don't run report
Exit Sub
End If

HTH--Lonnie M.