I am getting the following error while executing my code in AIMMS.
“spreadsheet::RetrieveTable(BCLOAD.xlsx, Load_Base(h,y,a), B3:CM8786, A3:A8786, B1:CM2, Load, 1) unable to get a handle to the workbook: Could not open Excel.”
I believe it is happening after some automatic updates on my Microsoft office. Previously it was working fine.
I tried to reinstall my office, change my excel file name, or even copied the project folder to my PC from the google drive. None of them resolved the issue.
It would be grate if you can help me with this issue.
Best answer by rezakhalili
It was working previously with this syntax.
However, I used the AXLL library and it solved the issue.