Introduction
Visual Basic for Applications (VBA) is a macro language that is built into Excel. This language makes it possible to control the content of workbooks, create user interfaces and perform advanced calculations. Using LiveLink™ for Excel® you can connect to a COMSOL server from Excel and access all the features of the COMSOL Application Programming Interface (API).
The interface based on VBA is using the model structure and the methods (commands) for accessing the model settings and data provided by the COMSOL API, with a similar programming syntax. You can refer to the COMSOL Programming Reference Manual for more information.
The following parts of the documentation show the steps necessary to work with COMSOL models starting with a very simple example based on an existing model.
The LiveLink™ for Excel® User’s Guide assumes that you have some knowledge of VBA.
The link information, which is added as comments to cells in a worksheet when using the buttons from the COMSOL tab and the methods from the RibbonUtil class, is not supported by methods in the COMSOL API for VBA.
See Updating and Solving a Model Using Excel® Macros for short examples to get started with using the COMSOL API for VBA.