I am working with a large Excel file that is used across multiple procedures. Loading/opening the Excel file into memory using axll::OpenWorkbook takes a very long time as a result of its size (think almost a minute long), and if at all possible, I would like to keep it open even after one procedure is done running such that the next procedure does not need to spend the time re-opening the workbook again.
My observation is that AIMMS automatically closes a workbook once a procedure is done running. Is there a way/option somewhere to keep the book loaded into memory? It would save our users quite a bit of time!
Thank you in advance!
Best answer by Chris KuipView original