Discussion Closed This discussion was created more than 6 months ago and has been closed. To start a new discussion with a link back to this one, click here.
Build a project from start to the end using vba
Posted Jun 3, 2016, 9:34 a.m. EDT Version 5.2 1 Reply
Please login with a confirmed email address before reporting spam
Hello,
Q1: I was wondering if one could build a complete project in EXCEL VBA, without having to use the desktop.
Q2: I understand how to save a project in VBA format. Is it possible to later edit the (saved) VBA project file and loaded back in COMSOL desktop?
Q3: Is the VBA file editable in the EXCEL VBA IDE (assuming the COMSOL Livelink is properly installed)?
Thank you
--
NAFTALI HERSCOVICI
Q1: I was wondering if one could build a complete project in EXCEL VBA, without having to use the desktop.
Q2: I understand how to save a project in VBA format. Is it possible to later edit the (saved) VBA project file and loaded back in COMSOL desktop?
Q3: Is the VBA file editable in the EXCEL VBA IDE (assuming the COMSOL Livelink is properly installed)?
Thank you
--
NAFTALI HERSCOVICI
1 Reply Last Post Jun 6, 2016, 7:53 a.m. EDT
Please login with a confirmed email address before reporting spam
Posted:
9 years ago
Hi
If you have LiveLink for Excel then this answers your questions:
Q1: Yes
Q2: You can't load the VBA file into Comsol again (edited or not), but you can run the VBA file (in Excel) and save the resulting model as a regular MPH-file that can later be loaded in Comsol Multiphysics. This feature is great for setting up advanced model and for debugging.
Q3: Yes, you can edit the VBA file inside Excel (it is just a text file).
--
Lars Gregersen
Comsol Denmark
If you have LiveLink for Excel then this answers your questions:
Q1: Yes
Q2: You can't load the VBA file into Comsol again (edited or not), but you can run the VBA file (in Excel) and save the resulting model as a regular MPH-file that can later be loaded in Comsol Multiphysics. This feature is great for setting up advanced model and for debugging.
Q3: Yes, you can edit the VBA file inside Excel (it is just a text file).
--
Lars Gregersen
Comsol Denmark