Run a procedure with parameters from Excel or with a VBscript

[jpays]

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

[ChrisHemedinger]

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

[jpays]

64-bit of EG 5.1

Looks like 32-bit of Excel.  I hope that's not a show stopper.

-Joe

[jpays]

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

[ChrisHemedinger · Accepted solution]

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

[jpays]

Thanks.

That yields the error below.  Any other thoughts?

[ChrisHemedinger]

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

[jpays]

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