Dynamic linking between Mathcad and Excel

[krokodilcho]

Hi Everyone!


I've been using Mathcad for a while and I believe it is a powerful tool. But in the last week I've been experiencing a problem. I need to create a dynamic link between Excel and Mathcad as the raw data I am working with is too much to be just copied or imported. There is a constant 'flow' of new information going straight into the excel file and I need it to be linked directly to Mathcad. (as we are talking here about thousands of results).

Will be very grateful if you can help me out! Thank you very much in advance!

Kate

 

[excognito]

Which version of Mathcad are you using? Do you need to simultaneously see the Excel workbook (within Mathcad or outside of it) or is just writing to it sufficient?

 

[krokodilcho]

Well, I am using Mathcad 15. For part of the data I need to see the the Excel workbook and for the rest I can just write it in (problem with that one is that data is too much to just copy and paste). Will be thankful if you can tell me how to do both.

 

[excognito]

I've replied to your question elsewhere, asking for a bit more information. I've mentioned the WRITEEXCEL and READEXCEL functions for data input and output.