Desktop productivity for business analysts and programmers

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

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 5
Accepted Solution

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

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


Accepted Solutions
Solution
‎04-17-2015 02:16 PM
Community Manager
Posts: 2,696

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

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

View solution in original post


All Replies
Community Manager
Posts: 2,696

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

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

Occasional Contributor
Posts: 5

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

64-bit of EG 5.1

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

-Joe

Occasional Contributor
Posts: 5

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

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

Solution
‎04-17-2015 02:16 PM
Community Manager
Posts: 2,696

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

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

Occasional Contributor
Posts: 5

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

Thanks.

That yields the error below.  Any other thoughts?

RegSvr32.png

Community Manager
Posts: 2,696

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

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

Occasional Contributor
Posts: 5

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

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

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 7 replies
  • 839 views
  • 0 likes
  • 2 in conversation