topic Re: Run a procedure with parameters from Excel or with a VBscript in SAS Enterprise Guide

Re: Run a procedure with parameters from Excel or with a VBscript

jpays — Fri, 17 Apr 2015 13:11:09 GMT

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

Re: Run a procedure with parameters from Excel or with a VBscript

ChrisHemedinger — Fri, 17 Apr 2015 17:26:43 GMT

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

Re: Run a procedure with parameters from Excel or with a VBscript

jpays — Fri, 17 Apr 2015 17:53:59 GMT

64-bit of EG 5.1

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

-Joe

Re: Run a procedure with parameters from Excel or with a VBscript

jpays — Fri, 17 Apr 2015 18:05:49 GMT

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

Re: Run a procedure with parameters from Excel or with a VBscript

ChrisHemedinger — Fri, 17 Apr 2015 18:16:33 GMT

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

Re: Run a procedure with parameters from Excel or with a VBscript

jpays — Fri, 17 Apr 2015 19:20:16 GMT

Thanks.

That yields the error below. Any other thoughts?

Re: Run a procedure with parameters from Excel or with a VBscript

ChrisHemedinger — Fri, 17 Apr 2015 19:31:43 GMT

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

Re: Run a procedure with parameters from Excel or with a VBscript

jpays — Fri, 17 Apr 2015 19:57:15 GMT

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