topic Execute excel macro's through SAS program in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/Execute-excel-macro-s-through-SAS-program/m-p/61160#M17355 <HTML><HEAD></HEAD><BODY><P> You might some more help if you this in the <A _jive_internal="true" href="https://communities.sas.com/community/integration_with_microsoft_office">http://communities.sas.com/community/integration_with_microsoft_office</A> forum. You also need to describe more how your application should work.</P><P>One idea is to use DDE, even though Microsoft doesn't favor (support?) this technique any more.</P><P></P><P>/Linus</P></BODY></HTML> Thu, 08 Sep 2011 07:22:34 GMT LinusH 2011-09-08T07:22:34Z Execute excel macro's through SAS program https://communities.sas.com/t5/SAS-Procedures/Execute-excel-macro-s-through-SAS-program/m-p/61159#M17354 <HTML><HEAD></HEAD><BODY><P>Dear All Friends,</P><P></P><P>I am new user. I have lot of interest in SAS programming.</P><P>Execute excel macro's through SAS program.</P><P></P><P>Does anyone have any ideas? </P><P>Please guide me.</P><P></P><P>Best Regards,</P><P>Pankaj</P></BODY></HTML> Wed, 07 Sep 2011 05:44:27 GMT https://communities.sas.com/t5/SAS-Procedures/Execute-excel-macro-s-through-SAS-program/m-p/61159#M17354 Pankaj_23 2011-09-07T05:44:27Z Execute excel macro's through SAS program https://communities.sas.com/t5/SAS-Procedures/Execute-excel-macro-s-through-SAS-program/m-p/61160#M17355 <HTML><HEAD></HEAD><BODY><P> You might some more help if you this in the <A _jive_internal="true" href="https://communities.sas.com/community/integration_with_microsoft_office">http://communities.sas.com/community/integration_with_microsoft_office</A> forum. You also need to describe more how your application should work.</P><P>One idea is to use DDE, even though Microsoft doesn't favor (support?) this technique any more.</P><P></P><P>/Linus</P></BODY></HTML> Thu, 08 Sep 2011 07:22:34 GMT https://communities.sas.com/t5/SAS-Procedures/Execute-excel-macro-s-through-SAS-program/m-p/61160#M17355 LinusH 2011-09-08T07:22:34Z Execute excel macro's through SAS program https://communities.sas.com/t5/SAS-Procedures/Execute-excel-macro-s-through-SAS-program/m-p/61161#M17356 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>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. </P><P></P><P>Cynthia</P></BODY></HTML> Thu, 08 Sep 2011 11:57:27 GMT https://communities.sas.com/t5/SAS-Procedures/Execute-excel-macro-s-through-SAS-program/m-p/61161#M17356 Cynthia_sas 2011-09-08T11:57:27Z