Microsoft Integration with SAS

Using SAS with Microsoft Azure and Microsoft applications
BookmarkSubscribeRSS Feed
danewt
Obsidian | Level 7

Hi Folks, 

We have a VBA Excel macro that's been in use in our enterprise for at least 5-10 years. The macro makes use of the SASWorkspaceManager 1.1 Type Library to connect to our Workspace Server to extract SAS data into Excel. We have some beta testers of MS Office 365 who are getting errors during the SAS connection step from the same VBA macro. The chief difference is that o365 is running as a 64bit app on Win11(x64) in the beta test environment while previously it runs in 32bit MS Office Excel installed on Win10(x64).

The error message is not very helpful. Something like, "Object not registered." It is raised in the VBA code with the first reference to SASWorkspaceManager during an object declaration. I'm wondering if this a bitwise issue between o365 and the SAS library.

The users are able to connect to the SAS Metadata Server without issue from the SAS Add-in in o365 Excel.

1 REPLY 1
danewt
Obsidian | Level 7

The text of the VBA error is, "Class not registered."

sas-innovate-white.png

Our biggest data and AI event of the year.

Don’t miss the livestream kicking off May 7. It’s free. It’s easy. And it’s the best seat in the house.

Join us virtually with our complimentary SAS Innovate Digital Pass. Watch live or on-demand in multiple languages, with translations available to help you get the most out of every session.

 

Register now!

Discussion stats
  • 1 reply
  • 1394 views
  • 0 likes
  • 1 in conversation