Invoking SAS EG using Excel VBA

[farrukh]

Hi,

I want to invoke my SAS EG scripts using Excel VBA, i have searched a lot regarding this but as i am not very well versed with VBA programming i am facing issues. It would be great if anyone can guide me in this. thanks in advance.

Farrukh

[RW9]

Why?  Excel if a file format, not a development suite.  If anything, drop the Excel part totally and do your work in SAS, outputting files for review.

[farrukh]

I am building an excel interface in my automation tool. I will take few user inputs as macro variables in order to trigger SAS and calculate the desired outcome. 

[RW9 · Accepted solution]

Use SAS EG prompts to get parameters for execution.

http://support.sas.com/resources/papers/proceedings17/0818-2017.pdf

[SASKiwi]

What about the SAS Add-In to Excel? You can run EG reports directly this way without using VBA.

[farrukh]

THANKS FOR YOUR REPLY, I WILL SURELY TRY THIS.

[AlanC]

Look at this post to get you started:

https://communities.sas.com/t5/Integration-with-Microsoft/Run-a-SAS-program-from-Visual-Basic-in-Exc...

Yours will be different since you want to go through EG. I think you should consider not having EG in the middle and submit to the SAS server directly. It is a lot easier. You need Integration Technologies client and you want to look at the workspace and the languageservice.