BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

Old VBA Code stopped working - ActiveX Errors

Search this topic... | Search SDK (VBA/ASP/JSP)... | Search Box
Register or Login to Post    Forum Index -> SDK (VBA/ASP/JSP)  Previous TopicPrint TopicNext Topic
Author Message
Forum Member
Forum Member

Joined: 14 Jul 2015

Posts: 9

PostPosted: Wed Oct 30, 2019 10:56 am 
Post subject: Old VBA Code stopped working - ActiveX Errors

I have had a side-by-side of the BOBJ 3.1 FP7.2 client tools and 4.2 SP5 Patch 1 client tools for almost a year. In the process of doing a migration from DeskI to WebI.

In this, I had built a macro in DeskI VBA which itterated through a set of reports and pulled out their query count, types, report tab count, etc...

This worked fine until this weekend when an admin decided to install the SAP Data Services 4.2 SP12 client in the same location which isn't compatible with 4.2 SP5.

Afterwards when we tried to run the macro we get an ActiveX can't create object error when Creating the session object. Something simple that worked before. I even tried to rewrite it to force the version 12 and same. So I figured the library registrations for 3.1 got messed up.

We removed the Data Services client and repaired both the 3.1 and 4.2 installs, but it still seems like it didn't register the components properly again.

I have even tried to re-write the code in VB.NET using the .NET assemblies for the session management and it fails there as well.

I have run a gacutil -i and regsvr32 on all the dlls in the dotnet folder but not sure what other registrations I am missing.

Any idea how to get at least the ActiveX components and dependencies to register again properly or have run into this before and how to fix it?

Thanks in advance.
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> SDK (VBA/ASP/JSP)  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0267 seconds using 18 queries. (SQL 0.0026 Parse 0.0008 Other 0.0232)
CCBot/2.0 (
Hosted by | Terms of Service
phpBB Customizations by the
Shameless plug for Moments of Light Logo