Exporting MathCad to specific Cells in Excel

[HelpAng]

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!!!!!!

 

[pmover]

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

 

[asmenut]

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.

 

[asmenut]

Also,

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.

 

[HelpAng]

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!!

 

[HelpAng]

I am using MathCAD 2000 and not yet have I added the Excel Add-On, where do I get it???

 

[asmenut]

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.

http://support.microsoft.com/newsgr...excel.programming&sd=GN&id=fh;EN-US;newsexcel