I would choose the latter. VB6/VBA have nothing in common with .NET I know … that's why I got excited earlier when you indicated Chris had written on the subject, but I am not finding that to be the case.  If you actually do find anything he's written on VBA with SAS, let me know.  Thanks.   ... View more

Thanks.  So far I have only found books he has written on - the closest I can get is .NET and IOM, but not VBA and IOM.  😞 ... View more

I assume we're both using the same Google 🙂 If you try googling his name with iom and vba, you'll see there are zero results except instances where you told people to search for him And if you search Amazon.com, there are no results at all - just a similarly named person who wrote books on Tennis Shoes.   So thanks for the link - very helpful, Amazon's search feature sucks I guess.  : ) ... View more

can't seem to find Chris's book on amazon or anything about chris on the internet  ? google 'no results' ... View more

I am not sure about sas.exe.  What I have on my laptop installed, is enterprise guide.  so when I open enterprise guide, then open task manager, then right click on EG process and go to file location, it's:  C:\Program Files (x86)\SAS94\x86\SASEnterpriseGuide\7.1 is that what you ask? ... View more

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". ... View more

Thanks for the tip on sas /regserver I'd like to follow up on that recommendation.  I am on a corporate-provided laptop at a BIIIIIIIG company.  Our stuff is locked down in every imaginable way.  I am unable to open the command prompt as administrator.   However, I would like to at least try to follow your advice before I involve Desktop Support at my company to run the command.   When you say "...where SAS is installed", do you mean that I have to open the command prompt...and change the current directory to the directory/folder where SAS is installed?  Or can you be more specific on that?  Or did you just mean, do this on the machine where SAS is installed?   Because did try running it and got 'sas' is not recognized as an internal or external command...etc.   I agree with you - this seems to be a matter of something, perhaps a DLL, not being fully registered.  Can I directly register the DLL itself using command prompt?   I agree with you and know that c# is the future, but right now in my current context, I have to try to use VBA in an Excel workbook.  I will try to learn c#. ... View more