Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA for automating a LINGO math program
Hi. I'm a grad student working on a nonlinear optimization problem for
my dissertation. I have a math programming model written in LINGO that I want to activate from Excel. Now I want to explore the sensitivity of the outputs to changes in the inputs by running many (100) different data sets per variable per toy network. So I'd like to use the power of VBA in Excel to call and run the LINGO model. The LINGO documentation only gets me so far - I can run the existing dataset and write to one place in Excel, but I haven't found documentation to automate changing the datasets and writing to different locations in my spreadsheet. Any help would be fantastic. Thank you. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA for automating a LINGO math program
Alix,
I don't know LINGO, but if you post how you are accomplishing the single run, then we can advise for the multiple situation. NickHK "Alix Demers" wrote in message ups.com... Hi. I'm a grad student working on a nonlinear optimization problem for my dissertation. I have a math programming model written in LINGO that I want to activate from Excel. Now I want to explore the sensitivity of the outputs to changes in the inputs by running many (100) different data sets per variable per toy network. So I'd like to use the power of VBA in Excel to call and run the LINGO model. The LINGO documentation only gets me so far - I can run the existing dataset and write to one place in Excel, but I haven't found documentation to automate changing the datasets and writing to different locations in my spreadsheet. Any help would be fantastic. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Less Excel more Math | Excel Worksheet Functions | |||
Is there a way to unload the loaded XLL file in Excel? Hi all, I amdebugging XLL link library using Visual C++. Everytime I rebuild the XLL, Ihave to close the whole Excel program and relaunch the Excel program again,and then load in the newly gene | Excel Discussion (Misc queries) | |||
Excel Language "lingo" | Excel Discussion (Misc queries) | |||
Excel Math Bug | Excel Programming | |||
merging excel program with tdc finance program | Excel Programming |