function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
DarrellKalichakDarrellKalichak 

Errors using Office Toolkit (VBA) with MS Project 2010

I'm developing an integration between MS Project and a custom object in my org. Everything works fine with MS Project 2003, I can move data back/forth between SFDC using VBA under the Office Toolkit (Version 4).

 

When I try the same exact code under MS Project 2010, I get errors. The application works fine the first time I access MS Project, but when I try to access it multiple times within the same session, the VBA crashes, bringing down MS Project 2010.

 

My code appears to be clean (i.e. I'm setting objects to nothing after using them), but I can't determine why my app is so fragile under MS Project 2010.

 

Has anyone seen this ? There must be some differences between the two (MSP 2003 and MSP 2010) that I am not aware of. 

 

Thanks,

Darrell