Hi, Thanks for the response. This workbook has three sheets. I'll get them to try and remove the two extra sheets. How did you get it to fail? I created a csv file with the same name and with all of the same sheet names and never got the error.
I'm getting an error stating that there is a "Runtime error '1004': cannot access '***.csv'. The window that this error is displaying in has the buttons "End" "Debug" and "Help". This is the code:
Public Flag As Boolean
Sub ReRun()
nextRun = Now + TimeValue("00:00:03")
Application.OnTime...