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.
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.
09-08-2011 07:57 AM
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.