VBA/COM "Class not registered"

[CarmineVerrell]

Looks like you might be missing some references.

Please take a look at integrating technologies for SAS 9.4 Platform 

SAS 9.4 Integration Technologies: Windows Client Developer's Guide

Developing Apps and communicating to SAS Viya

SAS for Developers | SAS

[ipisors]

If you look at the link I provided, I have already checked the two references that they suggest.  

Plus, knowing VBA, if I was missing a reference I would get a 'user-defined type' error, not "class not registered".

[CarmineVerrell]

Hmmm not entirely sure why the VB code isn't working. 

You might want to try the Microsoft Community site for VB code

Visual Studio Community 2019 - Free IDE and Developer Tools (microsoft.com)