×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Exporting MathCad to specific Cells in Excel

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

RE: Exporting MathCad to specific Cells in Excel

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

RE: Exporting MathCad to specific Cells in Excel

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.

RE: Exporting MathCad to specific Cells in Excel

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.

RE: Exporting MathCad to specific Cells in Excel

(OP)
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!!

RE: Exporting MathCad to specific Cells in Excel

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

RE: Exporting MathCad to specific Cells in Excel

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/newsgroups/default.aspx?IC...

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources