Desktop productivity for business analysts and programmers

Help required: EG project through VB coding in excel

Reply
N/A
Posts: 0

Help required: EG project through VB coding in excel

I am trying to run an EG program using _EXCEL VBA_.

The way its planned is the inputs are given through Excel and SAS EG will execute the program with these inputs in the backend.

We are using EXCEL VBA codes for this.
the SAS 9.1 version is given below.

Sub test()
Dim sasobj As Object
Set sasobj = CreateObject("SAS.Application")
sasobj.Visible = True
sasobj.submit "%inc '\\Team\Hashim\testcode.sas' ;"
End Sub

The above code is not functioning in SAS EG. Can you hep me in converting this to SAS enterprise Guide 3.0 code.

Thanks,
Hashim
Ask a Question
Discussion stats
  • 0 replies
  • 97 views
  • 0 likes
  • 1 in conversation