In the attached Mathcad 15 work sheet an Excel component spreadsheet has been inserted. The spread sheet has a Visual Basic program that uses input from cells on sheet1 and outputs a result in cell E11. Mathcad is to calculate the input variables and assign them to cells E4 to E9. Then Mathcad is to read the result from Excel in cell E11 for use in the remainder of the Mathcad worksheet.
The problem is it doesn't work. Mathcad presents an error message that says "invalid cell ranges" and then locks up Mathcad. The spreadsheet outside of Mathcad works perfectly?
Is there something wrong with the way I'm trying to integrate the two programs? Is there something wrong with the cell references?
I didn't write the VBA program in the Excel worksheet. It may be simpler to convert the program to a Mathcad program but I'm not conversant with VBA programming to do this. Would appreciate help it the problem above can't be fixed.
The lookup routines should be direct to the Wbeam excel file.