LiveLink™ for Excel®

Save Model Files for VBA

For a long time, the COMSOL Multiphysics® software files have been able to be saved as Java® files and M-files, but in version 5.1, you can also save a model in Visual Basic® development system for Applications (VBA) code. Using the COMSOL API in VBA, you can create subroutines to control COMSOL Multiphysics® simulations from within Microsoft Excel® spreadsheet software, including all aspects of modeling such as setting up models, changing settings, solving models, and postprocessing and extracting results to Excel® spreadsheet software.

Using LiveLink™ for Excel® and the added support for VBA, you can use Excel® spreadsheet software to handle all the data that you need to process, such as connecting to databases and other sources of data. You can also easily share your Excel® spreadsheet software files with your coworkers, even if they do not use COMSOL Multiphysics® simulation software.

Exported code from the Ion Drift Velocity Benchmark model. This code can be used to set up the model in Excel® spreadsheet software using VBA. The use of VBA makes it possible to access and change all aspects of a COMSOL Multiphysics  model and to extract data from the solved model. Exported code from the Ion Drift Velocity Benchmark model. This code can be used to set up the model in Excel® spreadsheet software using VBA. The use of VBA makes it possible to access and change all aspects of a COMSOL Multiphysics model and to extract data from the solved model.

Exported code from the Ion Drift Velocity Benchmark model. This code can be used to set up the model in Excel® spreadsheet software using VBA. The use of VBA makes it possible to access and change all aspects of a COMSOL Multiphysics model and to extract data from the solved model.

Save and Load Excel® Spreadsheet Software Files

You are now able to load and save Excel® spreadsheet software files even if Excel® spreadsheet software is not installed on your computer. This enables access to Excel® spreadsheet software files from a wider range of computers and operating systems. It also provides the ability to access Excel® spreadsheet software files from an app created with the Application Builder in COMSOL Multiphysics®.


Microsoft and Excel are registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries.

Oracle and Java are registered trademarks of Oracle and/or its affiliates.