Repost: Office 2007 Applications Automation and Visio 2010 Conflict

[SteveM]

Repost for potential MVP help.

I have Visio models that call Excel and Access explicitly. The models
work fine with Office 2007/Visio 2007 and with the proper application
Reference Library added to the VBA projects.

However, the code fails with Visio 2010. I tracked the problem down
to some kind of conflict between the Office 12 object library
associated with 2007 and the Office 14 library installed with Visio
2010 Beta.

Removal of Visio 2010 and the associated Office 14 library makes the
problem go away.

But now of course I can't continue to test Visio 2010 and still work
on my existing models.

Anybody have any ideas on how to resolve this?

Thanks Much,

SteveM

 

[SteveM]

Repost for potential MVP help.

I have Visio models that call Excel and Access explicitly.  The models
work fine with Office 2007/Visio 2007 and with the proper application
Reference Library added to the VBA projects.

However, the code fails with Visio 2010.  I tracked the problem down
to some kind of conflict between the Office 12 object library
associated with 2007 and the Office 14 library installed with Visio
2010 Beta.

Removal of Visio 2010 and the associated Office 14 library makes the
problem go away.

But now of course I can't continue to test Visio 2010 and still work
on my existing models.

Anybody have any ideas on how to resolve this?

Thanks Much,

SteveM

P.S. My models fail even using Visio 2007 and Excel/Access 2007. The
Office 14 conflict arises even without Visio 2010 being loaded.

 

[AlEdlund]

That's why a bunch of us are using virtual machines. You end up in the same
quandry if you want to test both 32 and 64 bit solutions (can't be loaded on
the same system at the same time, and there is NO x64 bit client support in
the Microsoft solutions).
al

 

[SteveM]

That's why a bunch of us are using virtual machines. You end up in the same
quandry if you want to test both 32 and 64 bit solutions (can't be loadedon
the same system at the same time, and there is NO x64 bit client support in
the Microsoft solutions).
al

Thanks Al.

So to close on this, the Office 12 and Office 14 conflicts are
irresolvable and I'm hosed unless/until I upgrade to Office 2010?

SteveM

 

[AlEdlund]

That was my understanding. With the caveat that sometimes some of these
issues about having two versions on the same system simultaneously are
resolved during the release cycle (I.e. rtm level code). The good news on
that is (my understanding) the release of 2010 is coming fairly soon.
al