I am trying to run a short program from Excel 2007 VBA to connect to a Pro/E session.
It is failing on the basic connection line:
Set conn = asynconn.Connect(", ", ".", 5)
The error message is:
Microsoft Visual Basic Run-time error '-2147352567 (80020009)': Automation error Exception Occurred.
The same program had worked past this initial point in Excel 2003 VBA, but we decided to try it in Excel 2007 because it had failed at a later point, and the person (Tech Support) who sent it to me had used Excel 2007.
So I think I have a basic setup problem. I have set up all the environment variables, etc.
Anybody familiar with this glitch?