It comes into my mind: "what has changed?"
I presume that you haven't modified this macro, so has anything changed in your Excel-file? Maybe someone is locking the file by having it open?
What happens if you try to read another Excel-file? Or from a different location?
If this macro uses then libname excel engine, that will explain the Proc SQL note, since it uses SQL to extract/update Excel sheets.
If this does not help, maybe this is a task for SAS support.
/Linus
... View more