Hi Chris,
New to SAS and having trouble create the app object ... something to the effect that the ActiveX can't create the object.
What are the prerequisites/dependence for making this work?
Dim app
Set app = CreateObject("SASEGObjectModel.Application.5.1")
I'm tring to fire up and run sas from within a VBA context/Excel 2010.
Any help is appreciated.
Thanks in advance.
-Joe
You can try this from a command prompt to register the automation API in the 32-bit registry:
c:\Windows\Microsoft.NET\Framework\v4.0.30319\regasm /codebase c:\Program Files\SASHome\SASEnterpriseGuide\5.1\sasegscripting.dll
Chris
Are you using the 32-bit version of EG 5.1? Or the 64-bit version? When running from within MS Office, the bitness must match between Office and SAS Enterprise Guide, since they will be in the same process (EXCEL.EXE).
Chris
64-bit of EG 5.1
Looks like 32-bit of Excel. I hope that's not a show stopper.
-Joe
FYI. Someone else in my group with the same setup seem NOT to have the same difficulty. Wondering in if the .dll need to be registered/certified/other. Let me know you need me to test anything out from this end.
Thanks again.
-Joe
You can try this from a command prompt to register the automation API in the 32-bit registry:
c:\Windows\Microsoft.NET\Framework\v4.0.30319\regasm /codebase c:\Program Files\SASHome\SASEnterpriseGuide\5.1\sasegscripting.dll
Chris
Thanks.
That yields the error below. Any other thoughts?
Are you sure that you ran regasm.exe and not regsvr32.exe ? This is a .NET library -- you need to run regasm.
SEGuide.exe /register also does this, but it might affect only your 64-bit registry which won't make things visible to your Microsoft Excel.
Chris
Oops. My bad - thought I had pasted your's but must have hit the up arrow instead.
All is well now. Thanks so much.
-Joe
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.