Mathcad and VBA Excel

[ptc-2620282]

Hi, I'm working with Excel macro to drive a Mathcad sheet. I use the method "GetValue" but it works only with numbers If I set a variable in Mathcad as a matrix, I can't use this method. How can I get back a Mathcad matrix in VBA? Thanks

[RichardJ]

Use GetValue. What you get back is an object, so to get the elements of the matrix you need to use the GetElement method. Richard

[ptc-2620282]

Thank you for your help, Richard I have another request : When I use the method Open to open a Mathcad file, it runs the job "mathcad.exe" but nothing appears at the screen. Is it possible to open the file in order to be available for the user in the taskbar of Windows? Yann

[RichardJ]

After you create the Mathcad object Set objMCApp = CreateObject("Mathcad.Application") you need the line: objMCApp.Visible = True Richard

[ptc-2620282]

Thanks, To get back to the Matrix, I would like to get back in VBA a matrix from a first mathcad sheet and to send the matrix in a second mathcad sheet Here is an extract from my code :

c8f9ea460a

The last line doesn't work. How can I send the matrix named O to the second file? Thanks Yann

[RichardJ]

Get rid of the line "Dim O As Object". Richard

[ptc-2793288]

Hi all, How to get value (getvalue) from mathcad in greek symbol by VB.NET Please help. LEO

[RichardJ]

"Leo Thomas" wrote:

Hi all, How to get value (getvalue) from mathcad in greek symbol by VB.NET Please help. LEO

[mgordon]

You can have a look at:

Excel matrix OLE with VBA and Mathcad

Best regards.

Mica Gordon