I am a full-time consultant and provide services related to the design, implementation and deployment of mathematical programming, optimization and data-science applications. I also teach courses and workshops. Usually I cannot blog about projects I am doing, but there are many technical notes I'd like to share. Not in the least so I have an easy way to search and find them again myself. You can reach me at erwin@amsterdamoptimization.com.
Monday, June 30, 2008
How to call GAMS from Excel using VSTO?
VSTO = Visual Studio Tools for Office (see http://msdn.microsoft.com/en-us/office/aa905533.aspx). This allows you to develop .NET code for use with Office applications. Basically newer versions of Office both host VBA and .NET. VBA code is stored embedded in the .xls file, while .Net is maintained outside the spreadsheet. MS Visual Studio has excellent tools to develop, debug and deploy VSTO based applications. The VBA code presented in http://www.amsterdamoptimization.com/packaging.html can be ported to .NET/VSTO without much problem.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment