cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Want the oppurtunity to discuss enhancements to PTC products? Join a working group! X

Will VB Macros Work in Excel Component?

EricSeelye
7-Bedrock

Will VB Macros Work in Excel Component?

Hi All,

I make frequent use of steam table calling functions in my Excel spreadsheets, and I would like to use this capability within Mathcad Prime 3.0. However, so far I have been unable to figure out how to bring a sheet with it's steam table calls into an Excel component in Mathcad Prime 3.0.

I think the functions are inside of a couple of .bas files, and I have tried to save those in the Excel component, but this seems to cause trouble with Mathcad.

I will attach a small sample Excel file showing how the calls work.

If anyone can advise how to make this work I would very much appreciate it.

Thanks,

--Eric Seelye

P.S. The steam calls in this sheet are the work of Magnus Holmgren (formerly of www.x-eng.com) However, he seems to have dropped out of site. I was unable to find him when I last tried some months ago. Anybody know what happened to him?

0 REPLIES 0
Top Tags