topic Re: xml to xls conversion in Microsoft Integration with SAS https://communities.sas.com/t5/Microsoft-Integration-with-SAS/xml-to-xls-conversion/m-p/135414#M1367 <HTML><HEAD></HEAD><BODY><P>I think this is resolved</P></BODY></HTML> Tue, 08 Apr 2014 14:59:26 GMT wkossack_nspirehealth_com 2014-04-08T14:59:26Z xml to xls conversion https://communities.sas.com/t5/Microsoft-Integration-with-SAS/xml-to-xls-conversion/m-p/135408#M1361 <HTML><HEAD></HEAD><BODY><P>I have a continuing problem of converting xml output to xls</P><P></P><P>I've tried to write an excel macro to do the conversion but I can never get it to work consistently in batch on our windows server</P><P></P><P>I've started looking for a open source solution that can be run from a command line so it can either be run from SAS or a batch program.</P><P></P><P>In a quick search I found</P><P>Total XML to XLS converter from CoolUtils.com ($49.90)</P><P>Novixys Exult XML Conversion Wizard ($195)</P><P></P><P>anyone have experience with these or other utilities</P></BODY></HTML> Thu, 06 Mar 2014 17:15:06 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/xml-to-xls-conversion/m-p/135408#M1361 wkossack_nspirehealth_com 2014-03-06T17:15:06Z Re: xml to xls conversion https://communities.sas.com/t5/Microsoft-Integration-with-SAS/xml-to-xls-conversion/m-p/135409#M1362 <HTML><HEAD></HEAD><BODY><P><A href="http://support.sas.com/kb/43/496.html" title="http://support.sas.com/kb/43/496.html">43496 - Convert files created using an ODS destination to native Excel files</A></P><P></P><P>VBS solution that's free and works <img id="smileyhappy" class="emoticon emoticon-smileyhappy" src="https://communities.sas.com/i/smilies/16x16_smiley-happy.png" alt="Smiley Happy" title="Smiley Happy" /></P></BODY></HTML> Thu, 06 Mar 2014 17:51:03 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/xml-to-xls-conversion/m-p/135409#M1362 Reeza 2014-03-06T17:51:03Z Re: xml to xls conversion https://communities.sas.com/t5/Microsoft-Integration-with-SAS/xml-to-xls-conversion/m-p/135410#M1363 <HTML><HEAD></HEAD><BODY><P>I've see this before</P><P></P><P>the problem is it pops up a window looking for the xml file which causes problems with sequential batch runs. </P><P></P><P>We are running on a windows server</P></BODY></HTML> Fri, 07 Mar 2014 22:41:43 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/xml-to-xls-conversion/m-p/135410#M1363 wkossack_nspirehealth_com 2014-03-07T22:41:43Z Re: xml to xls conversion https://communities.sas.com/t5/Microsoft-Integration-with-SAS/xml-to-xls-conversion/m-p/135411#M1364 <HTML><HEAD></HEAD><BODY><P>It didn't for me...</P></BODY></HTML> Fri, 07 Mar 2014 22:43:38 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/xml-to-xls-conversion/m-p/135411#M1364 Reeza 2014-03-07T22:43:38Z Re: xml to xls conversion https://communities.sas.com/t5/Microsoft-Integration-with-SAS/xml-to-xls-conversion/m-p/135412#M1365 <HTML><HEAD></HEAD><BODY><P>I have been fighting this for more than a year.&nbsp; I had an excel macro that was working but a windows update did something and my macro no longer works consistently.</P><P></P><P>Just like the windows update a year ago that made it so you can't open XML files as spreadsheets through a browser</P></BODY></HTML> Fri, 07 Mar 2014 22:48:02 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/xml-to-xls-conversion/m-p/135412#M1365 wkossack_nspirehealth_com 2014-03-07T22:48:02Z Re: xml to xls conversion https://communities.sas.com/t5/Microsoft-Integration-with-SAS/xml-to-xls-conversion/m-p/135413#M1366 <HTML><HEAD></HEAD><BODY><P>There's an line in the code that says Display Alerts = True, have you tried changing that to False?</P><P>I'm on a mac today, so can't test anything and don't have a windows server anyways <img id="smileysad" class="emoticon emoticon-smileysad" src="https://communities.sas.com/i/smilies/16x16_smiley-sad.png" alt="Smiley Sad" title="Smiley Sad" /></P></BODY></HTML> Fri, 07 Mar 2014 22:51:54 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/xml-to-xls-conversion/m-p/135413#M1366 Reeza 2014-03-07T22:51:54Z Re: xml to xls conversion https://communities.sas.com/t5/Microsoft-Integration-with-SAS/xml-to-xls-conversion/m-p/135414#M1367 <HTML><HEAD></HEAD><BODY><P>I think this is resolved</P></BODY></HTML> Tue, 08 Apr 2014 14:59:26 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/xml-to-xls-conversion/m-p/135414#M1367 wkossack_nspirehealth_com 2014-04-08T14:59:26Z