Transfer data from MathCad to Ms Excel
Transfer data from MathCad to Ms Excel
(OP)
Hello,
Im a aerospace engineer (stress), does anyone know what's the best way to transfer data from Excel to Mathcad. I have this problem: I've got a method in a mathacad file that runs one case entering some data manually into the sheet. But I have to run 200 cases so I am thinking about design a macro VBA from excel that opens my mathcad method, enters the inputs (from excel) and obtans the outputs (to excel) afterwards in just one click. Any ideas about the code to use in the macro to I/O operations. I learnt FORTRAN at school so, no much Objcts Oriented Programming idea.
Thank you.
manurico
Im a aerospace engineer (stress), does anyone know what's the best way to transfer data from Excel to Mathcad. I have this problem: I've got a method in a mathacad file that runs one case entering some data manually into the sheet. But I have to run 200 cases so I am thinking about design a macro VBA from excel that opens my mathcad method, enters the inputs (from excel) and obtans the outputs (to excel) afterwards in just one click. Any ideas about the code to use in the macro to I/O operations. I learnt FORTRAN at school so, no much Objcts Oriented Programming idea.
Thank you.
manurico






RE: Transfer data from MathCad to Ms Excel
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: Transfer data from MathCad to Ms Excel
Thanks anyway for your help.
Manuel
RE: Transfer data from MathCad to Ms Excel
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: Transfer data from MathCad to Ms Excel
Thanks
RE: Transfer data from MathCad to Ms Excel
RE: Transfer data from MathCad to Ms Excel
I eventually managed to control the mathcad file inserting it in a excel file as a OLE object. Seems to work well, although it is not the cleanest thing in the world.
I was wondering if someone know how to send inputs to mathcad from a external source (.xls,.txt,.csv,...) and get the outputs back from mathcad to excel, etc... But doing all this without opening the mathcad file, but just creating a interface program in VB, that calls the M/C file and manages the data.
Thanks
RE: Transfer data from MathCad to Ms Excel
As for running mathcad, what's the issue? You shell to the DOS shell, and call the program with the file you want it to run. You have the Mathcad file output a .csv file and read it back in.
TTFN
FAQ731-376: Eng-Tips.com Forum Policies