This code is not for beginner or end users. You can consult the documentation to learn the details of the SAS code. You will need the MACROFUN documentation from MicroSoft to learn details about SELECT.SPECIAL and CLEAR. I'm not sure where the details of EXEC|SYSTEM are documented.
The code I posted assumes the XL file is open, which I see you are able to do from looking at the code you posted.
No need to report the results, I know what the program does.
... View more