View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Cor Steeghs Cor Steeghs is offline
external usenet poster
 
Posts: 5
Default VBE calls Mathcad 8 in Excel97

I would appreciate any of your help in the following:
Using Mathcad 8 from within Excel-VBE, like :
-- Set mathcadobject = Worksheets("MATHCAD").OLEObjects(1).Object
principally works well.
Problems arise after several calls and succesfull calculations in
Mathcad.
Suddenly VBE appears to have problems in the link with Mathcad,
messaging :
-- Run time error '1004' :
-- Unable to get the objects properties of the Worksheet class
Is there a remedy for this problem ?
Thanks very much for your attention and/or reply and best regards,
Cor Steeghs