This is AIMMS 4.37.4.
I’m in an institutional computing scenario that has an institution-wide subscription to Microsoft Office 365. Due to my changeover from fulltime employee to contract consultant, my use of Office 365 is temporarily suspended and this energy modeling suite I run that uses AIMMS (I didn’t write the AMS code, which is why the use of a newer version of AIMMS is contraindicated) and AIMMS is stopping and throwing this in aimms.err:
spreadsheet::CloseWorkbook(CoalOutput-1.xls, 1) failed: Error when enabling user alerts in Excel. Unknown error 0x800A03EC.
Ultimately an excel.exe process is left behind taking up CPU time indefinitely.
It seems that there is something about CloseWorkbook() that is doing more than just opening and writing a file. Is it the case that this function reaches out to Excel to get it to do something, and if so is there a workaround? I note that these spreadsheet-related functions can be made to traffic in .ods files (LibreOffice/OpenOffice) instead and I could possibly hack in an .ods/.xls conversion via command line to run after the fact using one or the other of those apps, but I wanted to see if a cleaner workaround existed.
BTW, if this behavior does not exist in the newer AIMMS version’s spreadsheet functions, it might be worth it to rewrite the modeling system’s .ams files and use a newer AIMMS.
Thanks!
