cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Want the oppurtunity to discuss enhancements to PTC products? Join a working group! X

Excel as an Component

tietjee
14-Alexandrite

Excel as an Component

I am using MathCAD 15 and would like to use excel as a component. The excel worksheet is 2010 with macro's. This will allow me to integrate the calucation done in MathCAD with the other program. The other program in OrcaFlex used analyze underwater mooring and cable systems. Your support is appreciated. David Tg

9 REPLIES 9
MikeArmstrong
5-Regular Member
(To:tietjee)

I am using MathCAD 15 and would like to use excel as a component. The excel worksheet is 2010 with macro's. This will allow me to integrate the calucation done in MathCAD with the other program.

What are the Macro's used for?

The other program in OrcaFlex used analyze underwater mooring and cable systems. Your support is appreciated. David Tg

I assume OrcaFlex can handle multiple inputs?

Mike

http://communities.ptc.com/servlet/JiveServlet/showImage/2-149416-2532/bar_anim.gif

Mathcad 15 currently supports up to Excel 2007, but not yet Excel 2010. Save your Excel sheet back down to 2007.

Mona

tietjee
14-Alexandrite
(To:mzeftel)

I still unable to use the excel worksheet as a component. Attached are the files. Thanks for the support

MikeArmstrong
5-Regular Member
(To:tietjee)

I still unable to use the excel worksheet as a component. Attached are the files. Thanks for the support

You haven't said what you want to achieve by placing the Excel sheet into Mathcad. It seems that a lot of time has gone into the Excel sheet so why would you want it in Mathcad?

Mike

http://communities.ptc.com/servlet/JiveServlet/showImage/2-149416-2532/bar_anim.gif

MikeArmstrong
5-Regular Member
(To:mzeftel)

Mathcad 15 currently supports up to Excel 2007, but not yet Excel 2010. Save your Excel sheet back down to 2007.

Mona,

I have no issue's using Excel components and don't have Excel 2010

Mike

http://communities.ptc.com/servlet/JiveServlet/showImage/2-149416-2532/bar_anim.gif

tietjee
14-Alexandrite
(To:MikeArmstrong)

The excel worksheet is provided with OrcaFlex. It is used for pre and post processing. It is easier to calculate some many of the physical properties in MathCAD and output them to the excel work sheet. The excel worksheet is mainly for organizing the input and output data. Where you able to get the MathCAD file I attached to work with the excel workbook. Thanks David Tg

MikeArmstrong
5-Regular Member
(To:tietjee)

Where you able to get the MathCAD file I attached to work with the excel workbook. Thanks David Tg

Yes, I downloaded the file but there was no interaction between Excel and Mathcad. If you are trying to pass results to an Excel worksheet I have a few functions which can achieve this.

If you are trying to call data or an excel component into Mathcad, well that's easy because Mathcad has built in features to deal with this.

Mike

http://communities.ptc.com/servlet/JiveServlet/showImage/2-149416-2532/bar_anim.gif

tietjee
14-Alexandrite
(To:MikeArmstrong)

Mike,

Thanks for the support. I looked closer to my MathCAD worksheet and found an error (spelling) and now it works. Surprise, surprise.

Thanks David Tg

MikeArmstrong
5-Regular Member
(To:tietjee)

Thanks for the support. I looked closer to my MathCAD worksheet and found an error (spelling) and now it works. Surprise, surprise.

No problem, spellings....... the amount of times they have caused me issues.

Mike

http://communities.ptc.com/servlet/JiveServlet/showImage/2-149416-2532/bar_anim.gif

Top Tags