File|Excel


windowsicon

On Windows, LINGO has some useful links to Excel, which are discussed in more detail in the Interfacing With Spreadsheets chapter. One of these features involves embedding a LINGO model in an Excel workbook. LINGO may then be accessed directly from Excel via a VBA macro. The end result is that the model appears to be seemlessly linked to Excel, which is helpful for users more familiar with Excel than they are with LINGO.

The File|Excel command is useful for LINGO models embedded in Excel, in that it facilitates the movement of models back and forth from Excel for testing within the LINGO GUI. The File|Excel|Write Model to Range command sends models from LINGO to a range within a specified Excel workbook. Whereas, the File|Excel|Read Model from Range loads a model from an Excel range into a LINGO model window. Examples of these commands may be found in the section OLE Automation Links from Excel.