Hi All,

I am trying to Compare the Table data in the word document with reference to the exported data from Web Application by means of Macros in MS Excel 2010. Everything is working as expected except Opening the exported part where trying to export the Crystal report in "Excel 1997-2003" format (.xls).

After clicking "Open" button (This was handled by WINAPI function) through the macros written in MS Excel 2010, the excel was not opened and seeing "Running download ....." in the Notification bar and Hence in Macros under VBA Project the new workbook was not listed and hence script failing with message "Error 9 - subscript out of range". Could you help me why the Excel is not opening even clicking "Open" button (during export).

As a workaround if I have a breakpoint (With On Error Resume Next) or by clicking debug button in window message "Error 9 - Subscript out of Range", the excel is opening and also displaying under "VBA Project" section in Macros. Kindly guide me to fix this issue.

OS: Window 10


Regards
vmanoharan