No replies to this topic

[rkb5693]

I recently downloaded the evaluation version of SuperPro designer v14 to see the COM functionality. That is basically whree you can use Excel to specificy conditions and it will bring up Superpro Designer and give you values back in excel. I also downloaded the example files where I saw the ComEx1, ComEx2, etc. files which I am attempting the use.

However, whenever I run the first macro (opening the file), I am getting a VBA error whenever the script tries to open the app. I am putting a screenshot below. 

This is happening in the first few lines of the VBA code right here:

The example files they have for download are actually setup with v13 so I had to manually go through and change to the designer.dlm file of the 14^th edition. And I've done other troubleshooting... both excel and superpro are 32 bit. I don't know what the issue might be. Does anyone have any background with using the COM funcitonality and what might be going wrong? Any help would be greatly appreciated.