Note: This discussion is about an older version of the COMSOL Multiphysics® software. The information provided may be out of date.

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.

How to install Livelink for Excel?

Please login with a confirmed email address before reporting spam

Hello,
I have license for Livelink for Excel and want to use it. I checked with te documentation and there are a lot of chapters starting with "With Livelink for Excel installed, you can do this and that" However I cannot find any information on HOW to install Livelink for Excel.
Can anybody please tell me how to do that?
Thanks
Kamil

4 Replies Last Post Nov 29, 2012, 3:07 p.m. EST
Erlend Kristiansen COMSOL Employee

Please login with a confirmed email address before reporting spam

Posted: 1 decade ago Nov 27, 2012, 2:16 a.m. EST
Hi,
Livelink for Excel is a module for COMSOL v.4.3a and newer. As you have a network license, I suspect that you have not yet installed the 4.3a version. In your COMSOL window, check in Help->About COMSOL Multiphysics for what version you are currently running. If you are indeed running v.4.3a and you do know that you have the Livelink for Excel module, then please contact support@comsol.com for further assistance.

Regards,
Erlend Kristiansen
Hi, Livelink for Excel is a module for COMSOL v.4.3a and newer. As you have a network license, I suspect that you have not yet installed the 4.3a version. In your COMSOL window, check in Help->About COMSOL Multiphysics for what version you are currently running. If you are indeed running v.4.3a and you do know that you have the Livelink for Excel module, then please contact support@comsol.com for further assistance. Regards, Erlend Kristiansen

Jim Freels mechanical side of nuclear engineering, multiphysics analysis, COMSOL specialist

Please login with a confirmed email address before reporting spam

Posted: 1 decade ago Nov 27, 2012, 9:51 p.m. EST
We had to go back after the normal installation and manually install the Excel for livelink using a Windows executable. The intended installation procedure never did work for us. This happened for every Windows installation we had (several).
We had to go back after the normal installation and manually install the Excel for livelink using a Windows executable. The intended installation procedure never did work for us. This happened for every Windows installation we had (several).

Please login with a confirmed email address before reporting spam

Posted: 1 decade ago Nov 29, 2012, 11:47 a.m. EST
Hello,
Thanks for the replies. I got tip from Comsol in Norway to first install Excel 2010 and then Comsol. When I followed this procedure it all went fine.
I have a question and/or a wish.
I find out from the Excel module that I must define the model and the geometry first. Later on I can change parameters and variables. I cannot define a model in Excel from bottom up. I mean the physics and geometry.
How can I achieve this? I mean define a new model, define geometry, define currents etc. and then solve Comsol?
I am comfortable with Excel so it would be very easy for me to do all this from Excel.
Are there any intentions on extending LiveLink for Excel so the user can control the whole model from Excel?
Alternatively is there a scripting or macro language in Comsol so I can automate my model building procedure?
Thanks
Kamil
Hello, Thanks for the replies. I got tip from Comsol in Norway to first install Excel 2010 and then Comsol. When I followed this procedure it all went fine. I have a question and/or a wish. I find out from the Excel module that I must define the model and the geometry first. Later on I can change parameters and variables. I cannot define a model in Excel from bottom up. I mean the physics and geometry. How can I achieve this? I mean define a new model, define geometry, define currents etc. and then solve Comsol? I am comfortable with Excel so it would be very easy for me to do all this from Excel. Are there any intentions on extending LiveLink for Excel so the user can control the whole model from Excel? Alternatively is there a scripting or macro language in Comsol so I can automate my model building procedure? Thanks Kamil

Jim Freels mechanical side of nuclear engineering, multiphysics analysis, COMSOL specialist

Please login with a confirmed email address before reporting spam

Posted: 1 decade ago Nov 29, 2012, 3:07 p.m. EST
I certainly cannot speak for COMSOL developers or tech support, but I don't think that is what this live link was intended for. I think the idea is that a model would be developed by a COMSOL user, then linked to Excel so that a person not acquainted with the COMSOL interface could vary parameters and other inputs from the Excel front end and run the COMSOL solver on the back end; which in turn, displays results back to Excel. I don't see how one could develop a model from scratch without using the COMSOL GUI, unless or course, you want to code everything up in MATLAB .m files.
I certainly cannot speak for COMSOL developers or tech support, but I don't think that is what this live link was intended for. I think the idea is that a model would be developed by a COMSOL user, then linked to Excel so that a person not acquainted with the COMSOL interface could vary parameters and other inputs from the Excel front end and run the COMSOL solver on the back end; which in turn, displays results back to Excel. I don't see how one could develop a model from scratch without using the COMSOL GUI, unless or course, you want to code everything up in MATLAB .m files.

Note that while COMSOL employees may participate in the discussion forum, COMSOL® software users who are on-subscription should submit their questions via the Support Center for a more comprehensive response from the Technical Support team.