I have a wee problem. I like to use excel spreadsheets within my mathcad files. To be exact I like the feature of using mathcad variables that feed into the excel doc, then take an excel cell and feed it out. So using an excel document as a little black box. I do this by using insert component, and selecting the number of inputs and outputs etc. However, I've recently discovered it doesn't seem to work with .xlsm files, that is macro enabled excel docs. When I attempt to do it my output mathcad variable goes red and says output range invalid. I've tried saving the excel doc as a 'Normal' .xls file and while it fixes this particular problem, the actual file no longer works.
Anyone else know what the problem is?
I've attached an example, file, where I've tried to embed a .xlsm as a "Component"
You'll see I can't take read any of the variables.
I can use the READEXCEL command, but that's not my intent. It needs to be a component.
My Mathcad version is MC15_M010_20110622
It seems that there is no support for files with a macro (it works fine with ".xls"/".xlsx"). Anyone tested? I use Mathcad 15 M045 and Microsoft Excel 2010.
Mathcad 15 is presently at relase M045, you're using M010.
You should be able to download and install the M045 release. Certainly if you are a maintenance customer.
No guarantee that that release will fix your problem, though.
Yes m15 050 is a service release. In anycase, it seems I'm about 4-5 releases out of date. I'll try get my companies IT department to update my Mathcad to 050 and see if that fixes my issue.
Can anyone on this site confirm whether or not they CAN get .xlsm file to work as embedded components?? Or am I chasing a dead end here?
"Can anyone on this site confirm whether or not they CAN get .xlsm file to work as embedded components?? Or am I chasing a dead end here?"
Isn't that what Vladimir did here: Re: Embedded 'Macro Enable' Excel Spreadsheet, i.e. **.xlsm files "It seems that there is no support for files...."?
So I got the M045 update. And it hasn't made any difference. Still CAN'T use embedded .xlsm files. That's a shame. I have found you can writeexcel(.) then readexcel(...). Then do a pasted link of the spreadsheet for presentation purposes. This sort of achieves the same thing. However is annoying as there is now an additional excel file in the file folder and I have open the excel spreadsheet to get it calculate. Still not the worst option though.
it seems an old post. But, has PTC implemented any solution?
Because I want to use macro enabled workbook as an excel component in Mathcad Prime 5.0.
It seems, software doesn´t support macro enabled workbook.