topic Re: Macro to convert XML to Excel in SAS Programming https://communities.sas.com/t5/SAS-Programming/Macro-to-convert-XML-to-Excel/m-p/122744#M25210 <HTML><HEAD></HEAD><BODY><P>Thanks data_null. I haven't had a chance to test but this is what I was looking for. Much appreciated.</P></BODY></HTML> Wed, 27 Feb 2013 16:05:27 GMT Tobin_Scroggins 2013-02-27T16:05:27Z Macro to convert XML to Excel https://communities.sas.com/t5/SAS-Programming/Macro-to-convert-XML-to-Excel/m-p/122742#M25208 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have several scheduled task that run in batch overnight and create 'Excel' file through ODS tagset. These files are then sent via email to the end users. I am using tagset for the formatting flexibility. However, some end users want to be able to see the spreadsheets on their i-phone/pad. The only way I know how to accomplish this is to open the file and re-save as an actual excel file.</P><P></P><P>Does anyone know of a macro or some code that would open and save the file to native excel in base SAS runniong in batch. Please say you do...pretty please.</P><P></P><P>Thanks,</P><P>Tobin</P></BODY></HTML> Wed, 27 Feb 2013 14:32:30 GMT https://communities.sas.com/t5/SAS-Programming/Macro-to-convert-XML-to-Excel/m-p/122742#M25208 Tobin_Scroggins 2013-02-27T14:32:30Z Re: Macro to convert XML to Excel https://communities.sas.com/t5/SAS-Programming/Macro-to-convert-XML-to-Excel/m-p/122743#M25209 <HTML><HEAD></HEAD><BODY><P>See if this thread is helpful.</P><P></P><P><A _jive_internal="true" href="https://communities.sas.com/message/124238#124238">https://communities.sas.com/message/124238#124238</A></P></BODY></HTML> Wed, 27 Feb 2013 15:36:20 GMT https://communities.sas.com/t5/SAS-Programming/Macro-to-convert-XML-to-Excel/m-p/122743#M25209 data_null__ 2013-02-27T15:36:20Z Re: Macro to convert XML to Excel https://communities.sas.com/t5/SAS-Programming/Macro-to-convert-XML-to-Excel/m-p/122744#M25210 <HTML><HEAD></HEAD><BODY><P>Thanks data_null. I haven't had a chance to test but this is what I was looking for. Much appreciated.</P></BODY></HTML> Wed, 27 Feb 2013 16:05:27 GMT https://communities.sas.com/t5/SAS-Programming/Macro-to-convert-XML-to-Excel/m-p/122744#M25210 Tobin_Scroggins 2013-02-27T16:05:27Z