Updating Excel Data in Aimms

[angelma...@gmail.com]

Hi all, 

I am trying to retrieve some parameters from excel spreadsheet into Aimms as follows:

Spreadsheet::SetActiveSheet( WorkbookName, "test" );

Spreadsheet::RetrieveParameter( WorkbookName, Demands, "DemandRange" );

However, when I change the values of "Demands" in excel and run the same procedure for the second time, the values in Aimms arent updated. 

After several attempts, I found that the values can only be updated if I close and reopen the Aimms project, and run the procedure again. Is there any solution to this?

Thanks a lot! :)))))))

[Mohan]

Hello,

Just close the Excel file using SpreadSheet::CloseWorkbook at the end of your procedure. The changes will be saved only when the workbook is not open in AIMMS.

[angelma...@gmail.com]

Hi Mohan,

Thanks for your advice, it works! :))