Exporting a matrix to Excel with VBA
Hello,
I would like to export a complete matrix from mathcad prime 8.0 to an existing Excel file and in a specified range of cells. While reading through some older posts on this topic, I got the feeling this shouldn't be too hard. I am, however, completely new to VBA. For now i have the following lines:
Sub ExportMatrixToExcel()
Dim MCApp As Ptc_MathcadPrime_Automation.Application
Dim WS As Ptc_MathcadPrime_Automation.Worksheet
Set MCApp = New Ptc_MathcadPrime_Automation.Application
MCApp.Visible = True
MCApp.Open ("E:\Mathcad\test.mcdx")
From here i would like to export the matrix in the mathcad file to my Excel file. The dimension of the matrix is 5x5 and let's say i want to place this matrix in Excel starting at C5 and ending at G9.
Is somebody willing to help me with this with a general example?
Thanks in advance


