Execute excel macro's through SAS program

Pankaj_23 · Posted 09-07-2011 01:44 AM

Dear All Friends,

I am new user. I have lot of interest in SAS programming.

Execute excel macro's through SAS program.

Does anyone have any ideas?

Please guide me.

Best Regards,

Pankaj

LinusH · Posted 09-08-2011 03:22 AM

You might some more help if you this in the http://communities.sas.com/community/integration_with_microsoft_office forum. You also need to describe more how your application should work.

One idea is to use DDE, even though Microsoft doesn't favor (support?) this technique any more.

/Linus

Data never sleeps

Cynthia_sas · Posted 09-08-2011 07:57 AM

Hi,

If you search on support.sas.com for examples of using the ODS TAGSETS.MSOFFICE2K_X destination, I believe it has a way to pass an Excel macro name from SAS/ODS to Excel. You use the ODS TAGSETS.MSOFFICE2K_X destination to create an HTML file from your procedure output ... and it is this HTML file that Excel knows how to open into worksheet form.

Cynthia