BookmarkSubscribeRSS Feed
wkossack_nspirehealth_com
Calcite | Level 5

I have a continuing problem of converting xml output to xls

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

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.

In a quick search I found

Total XML to XLS converter from CoolUtils.com ($49.90)

Novixys Exult XML Conversion Wizard ($195)

anyone have experience with these or other utilities

6 REPLIES 6
wkossack_nspirehealth_com
Calcite | Level 5

I've see this before

the problem is it pops up a window looking for the xml file which causes problems with sequential batch runs.

We are running on a windows server

Reeza
Super User

It didn't for me...

wkossack_nspirehealth_com
Calcite | Level 5

I have been fighting this for more than a year.  I had an excel macro that was working but a windows update did something and my macro no longer works consistently.

Just like the windows update a year ago that made it so you can't open XML files as spreadsheets through a browser

Reeza
Super User

There's an line in the code that says Display Alerts = True, have you tried changing that to False?

I'm on a mac today, so can't test anything and don't have a windows server anyways Smiley Sad

wkossack_nspirehealth_com
Calcite | Level 5

I think this is resolved

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

Discussion stats
  • 6 replies
  • 3762 views
  • 0 likes
  • 2 in conversation