Execute excel macro's through SAS program

[Pankaj_23]

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]

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

[Cynthia_sas]

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