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.
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.