Execute Excel VBA Macro using SAS

pramod_duvvuri — Wed, 04 Apr 2018 00:14:03 GMT

I have SAS EG version 7.1 and Office 2013 Installed on my system. I am trying to run my SAS projects by calling them from VBA. As a first step, I tried to call a simple PROC step using the below code I found online:

Sub createTable()
    Dim obObjectFactory As New SASObjectManager.ObjectFactory

    Dim obObjectKeeper As New SASObjectManager.ObjectKeeper

    Dim obServer As New SASObjectManager.ServerDef

    Dim obSAS as SAS.workspace
    
    Dim query as String
    query = "PROC SQL; CREATE TABLE ME.TABLE1; RUN;"

    obServer.MachineDNSName = "XXXXXXXXX"
    obServer.Protocol = ProtocolBridge
    obServer.Port = 8561
    obObjectFactory.LogEnabled = True

    Set obSAS = obObjectFactory.CreateObjectByServer("SASApp", True, obServer, "", "")

    obSAS.LanguageService.Submit query
    
End Sub

But I'm getting an error at below line:

Set obSAS = obObjectFactory.CreateObjectByServer("SASApp", True, obServer, "", "")

Can anyone please help me to move forward this error? Also, any guidance to run the SAS projects is greatly appreciated. I am new to both VBA and SAS.

Re: Execute Excel VBA Macro using SAS

ChrisNZ — Wed, 04 Apr 2018 05:06:54 GMT

Have a read here (for code, but your code seems fine) and here (for a similar IT connection error).

Test your connection with itconfig2.exe .

Re: Execute Excel VBA Macro using SAS

Kurt_Bremser — Wed, 04 Apr 2018 06:13:07 GMT

I moved the post to "Integration with MS Office", which seems a more appropriate forum.

topic Execute Excel VBA Macro using SAS in Microsoft Integration with SAS

Execute Excel VBA Macro using SAS

Re: Execute Excel VBA Macro using SAS

Re: Execute Excel VBA Macro using SAS