Thanks Chris for your reply. However, that did not seem to work either. We ended up eliminating the need to open the Excel file all together by moving all the calculations to SAS from excel. ... View more

Thank you for your reply. Since the code was handed over from someone else, we were trying to see if there is a way to make this work without have to transfer all the calculations to SAS that. However, that is what we ended up doing - moving the calculations to SAS. ... View more