Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!
Exporting MathCad to specific Cells in Excel
- Thread starter HelpAng
- Start date
while i do not know if it is possible nor the objective of your task, an alternative is to insert another sheet in workbook and use that worksheet as the source of exported data. then conduct the analysis and/or calcs on other worksheets using the source worksheet.
several years ago while conducting analysis on engines and compressors, that is what i ended up doing. the software had capabilities of exporting to excel, but not in a desirable format. therefore, i set up a worksheet that contained the exported data and then i made the analysis and calcs on other sheets by obtaining the data from the source worksheet.
good luck!
-pmover
several years ago while conducting analysis on engines and compressors, that is what i ended up doing. the software had capabilities of exporting to excel, but not in a desirable format. therefore, i set up a worksheet that contained the exported data and then i made the analysis and calcs on other sheets by obtaining the data from the source worksheet.
good luck!
-pmover
Integrating Mathcad into an Excel worksheet
If you want to use Mathcad's functionality while in Excel, you can use Mathcad as an OLE automation server. To do so, you must write a program in Excel using Visual Basic 5.0 or higher. You use the program to define and retrieve variables in Mathcad Document objects. This allows you to:
Send data dynamically to Mathcad from Excel.
Use Mathcad to perform calculations or other data manipulations.
Send results back to Excel.
If you want to use Mathcad's functionality while in Excel, you can use Mathcad as an OLE automation server. To do so, you must write a program in Excel using Visual Basic 5.0 or higher. You use the program to define and retrieve variables in Mathcad Document objects. This allows you to:
Send data dynamically to Mathcad from Excel.
Use Mathcad to perform calculations or other data manipulations.
Send results back to Excel.
- Thread starter
- #5
How does this allow you to specify the exact cell location in excel, What I mean is that I am trying to do a calculation then extract it to a matrix table, where then i take the information into an excel file for another program to read. However the other program requires me to input titles and when i input data from MathCAD it going directly to cells A1 where as I stated before I require it to start at Cell A2 leaving A1 empty, and even if it is empty it will import a zero (0) and messes up my file. Could you explain more about what you did for your project please!!
- Thread starter
- #6
1) To get the Addin, goto Mathcad.com and look in the
downloads section.
2) When you use VBA to program the setup, you Call the Application (in this case MathCad) to access the ranges you need (you will need to format the Worksheet with Range Names).
I am not the one to ask about how to do the VBA as I am just learning myself (prefer Engineering, not programming), but you can go to the Excel Community Forums to ask how.
downloads section.
2) When you use VBA to program the setup, you Call the Application (in this case MathCad) to access the ranges you need (you will need to format the Worksheet with Range Names).
I am not the one to ask about how to do the VBA as I am just learning myself (prefer Engineering, not programming), but you can go to the Excel Community Forums to ask how.
- Status
Similar threads
- Locked
- Question