LiveLink™ for Excel® Updates

For users of LiveLink™ for Excel®, COMSOL Multiphysics® version 6.0 brings improved support for Visual Basic® for Applications (VBA) and the ability to include expressions in exported data. Read more about these updates below.

Ribbon Commands in VBA

Support for VBA has been improved with a new VBA command for all the buttons in the COMSOL Multiphysics® ribbon. This functionality allows you to use the toolbar button commands directly from VBA code, which makes it easier to automate steps that were easy to perform using the ribbon, but perhaps difficult to perform using the COMSOL API. This aids in the transition from using the ribbon for simple tasks to using VBA to fully automate the process of handling model data with Excel® and COMSOL Multiphysics®.

In the image below, the VBA command RibbonUtil.InsertGeometryGraphics(string modelTag) has the same effect as clicking the Geometry button in the ribbon. This command may be combined with other ribbon commands and other commands in the COMSOL API.

A closeup view of an Excel workbook showing the Geometry button and the VBA option.
A Microsoft Excel® workbook is open with a COMSOL model showing the tooltip for the Geometry button, which shows the VBA command.

writeExcelFile

When saving Excel® data from apps, you can include expressions in the exported data, available when using the writeExcelFile file method.


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