HI, I have a working 4GL code that creates 2 Excel worksheets using ActiveX automation. No activeX controls are used. I recently installed MS-EXCEL 2013 32 Bit on a windows 64 bit machine. The same code started giving "exception error". The error message number is 5890. During debug, I found out that the same code is able to create first spreadsheet but creates an error while trying to create 2nd worksheet. I tried recompiling code on same machine with office 13 but that did not help. If i run the program and generate EXCEL with 2 worksheets in Office 10, the same can be open in Office13 without issues. Any help in this matter would be highly appreciated.
I would suggest contacting Progress Technical Support for assistance. If the only difference is MS-EXCEL 2013, then this suggests there might be an issue with MS-EXCEL, but that would need further investigation to determine.
Also, if this an issue specific to MS-EXCEL 2013, then you could try to reproduce the problem outside of OE. There might already be posts similar to this on other forums.
I would suggest contacting Progress Technical Support for assistance. If the only difference is MS-EXCEL 2013, then this suggests there might be an issue with MS-EXCEL, but that would need further investigation to determine.
Flag this post as spam/abuse.
Puneet,
You could try starting macro recording, insert your first worksheet, do some things to it, insert the second worksheet, stop the macro recording and look at the resulting macro. That might give you something that you can use to determine what is different between the 2013 version of Excel and earlier versions.
Brian