Exporting results to Excel

Forum|Forum|13 years ago
September 11, 2012
3 replies
6230 views

I am running MathCAD 15 and Office 2007. I am trying to export results from a MathCAD calculation to an Excel workbook. MathCAD will not export the values and provides the error "The range value specified is invalid." There are two varibles that are exported, each to individual cells into a Excel worksheet. This is a multi sheet Excel macro enable work book. Is it possible to use the Insert Component to export varibles to a Macro-Enable Worksheet?

Mathcad Usage

M

MichaelH

1-Visitor

David Tietje wrote:
MathCAD will not export the values and provides the error "The range value specified is invalid."

Have you tried writing the result to a text file and having Excel read that file?

Do you have an example Mathcad file you can attach to you post?

R

RichardJ

19-Tanzanite

I don't think it should make any difference whether or not macros are enabled. How are you doing the export? Via the WRITEEXCEL function?

T

tietjee

Author

15-Moonstone

I am trying to attached a zip with both the MathCAD and Excel files. I do not see the upload bottom. The Excel worksheet is macro-enabled. This is required to integrate with another program. The insert Component causes the error, and is highlighted in yellow. I am able to export the information using the WRITEEXCEL, which is highlighted in red.

regards,