topic Invoking SAS EG using Excel VBA in SAS Enterprise Guide

Invoking SAS EG using Excel VBA

farrukh — Tue, 12 Dec 2017 13:30:50 GMT

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

Re: Invoking SAS EG using Excel VBA

RW9 — Tue, 12 Dec 2017 14:02:34 GMT

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.

Re: Invoking SAS EG using Excel VBA

farrukh — Tue, 12 Dec 2017 14:18:21 GMT

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.

Re: Invoking SAS EG using Excel VBA

RW9 — Tue, 12 Dec 2017 14:24:27 GMT

Use SAS EG prompts to get parameters for execution.

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

Re: Invoking SAS EG using Excel VBA

SASKiwi — Tue, 12 Dec 2017 21:02:54 GMT

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

Re: Invoking SAS EG using Excel VBA

AlanC — Wed, 13 Dec 2017 04:52:03 GMT

Look at this post to get you started:

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

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.

Re: Invoking SAS EG using Excel VBA

farrukh — Wed, 13 Dec 2017 07:11:36 GMT

THANKS FOR YOUR REPLY, I WILL SURELY TRY THIS.