How to run SAS Stored process excel add in without opening excel?

venkiparki_gmail_com — Mon, 19 May 2014 18:56:47 GMT

I have successfully connected the excel sheet with the SAS stored process. It runs whenever the file opens and refreshes the data within 30-40 seconds. I am wondering if there is a way to run this stored process without opening the excel file every time. Say I wanted to schedule this to update the sheet every day at 8AM. Can this be done using Windows schedule task?

Also, I am wondering if anyone has experience with Auto_Open macro in VBA. The stored process data feeds this excel macro to create several graphs. These graphs are then printed as PDF and uploaded into a webpage using DMS (CMS) every day. I wanted to automate these completely using:

SAS Stored process --> Excel SAS Add in --> Auto_Open update macro --> VBA to print PDF --> Web reporting studio to create a static link to place it in the web

I wanted to run the stored process before running the Auto_Open macro, so it uses updated data every day. When I tried to do this, I always ended up with Auto_Open running before stored process while opening the file. I tried wait and all, but nothing seems to be working. I know all the graphs can be done in SAS and it would make the job easier without involving excel in the picture.

If you have any thoughts or ideas, I would love to hear from you.

Thanks!

park

Re: How to run SAS Stored process excel add in without opening excel?

RMP — Wed, 21 May 2014 15:25:57 GMT

A stored process is simply a SAS program with some accompanying metadata. The SAS program can be executed in a batch process. This process can be then scheduled to run on a daily basis.

HTH.

Richard

topic Re: How to run SAS Stored process excel add in without opening excel? in SAS Data Management

How to run SAS Stored process excel add in without opening excel?

Re: How to run SAS Stored process excel add in without opening excel?