Exporting MathCad to specific Cells in Excel
Exporting MathCad to specific Cells in Excel
(OP)
I need to export data from MathCad to specific cell ranges within Excel, where normally in MathCad it automatically starts at A1, where I want it to start at A3
Can someone tell me if this is possible!!!!!!
Can someone tell me if this is possible!!!!!!





RE: Exporting MathCad to specific Cells in Excel
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
RE: Exporting MathCad to specific Cells in 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.
RE: Exporting MathCad to specific Cells in Excel
What version of MathCad are you using? And do you have the Excel Add-In for MathCad?
If you write the VBA, you can designate where you want the data to go. Not sure how, since I have yet to integrate the two.
RE: Exporting MathCad to specific Cells in Excel
RE: Exporting MathCad to specific Cells in Excel
RE: Exporting MathCad to specific Cells in Excel
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.
http://support.microsoft.com/newsgroups/default.aspx?IC...