I need to write some data to excel and wanted to use COMatePLUS to do it. I am running PB 5.50 Windows X64, COMatePLUS Version 1.2 released 09th July 2010, and Excel 2016. I can run the Demo_Excel.pb file stand alone without issue. Everything works.
When I try to run the same code from inside my program however I get an error:
[13:51:07][ERROR] COMatePLUS.pbi (Line: 1383)
[13:51:07][ERROR] Procedure stack has been corrupted.
I have tried calling this same method from a separate file I was going to use for COMatePLUS related code and on getting this error there, I tried moving the code into my main file, thinking there may be some issue with context or the like. Neither one works, and I get the same error both times.
The line in my code I am getting the error on is this one - straight from Demo_Excel.pb but running in my main.pb file:
Code: Select all
If ExcelObject\SetProperty("Visible = #True") = #S_OK
Thanks,
Eddie