topic Re: error "The converter failed to save the file." in ODS and Base Reporting

error "The converter failed to save the file."

wkossack_nspirehealth_com — Mon, 11 Mar 2013 21:13:58 GMT

I create a spreadsheet with

ods tagsets.ExcelXP

but later I need to open it again to use DDE to manipulate it

error "The converter failed to save the file."

anyway around this?

Re: error "The converter failed to save the file."

Reeza — Tue, 12 Mar 2013 00:35:45 GMT

I haven't seen this error before, can you post the code you're using that has the issues?

Re: error "The converter failed to save the file."

Cynthia_sas — Tue, 12 Mar 2013 01:18:00 GMT

Hi:

A quick Google search indicates that this is a MICROSOFT error message and not a SAS error message. So, my guess is that either

1) your DDE is opening the file created by SAS (Spreadsheet Markup Language XML 2003) and DDE doesn't recognize that format or

2) you try some manipulation before Excel is open, or your open of the file fails for some reason.

To me, this would seem to be a question for a Microsoft forum along the lines of:

If I have an XML 2003 file, how can I open that file and modify it using DDE? I am getting an Excel error that says error "The converter failed to save the file" I would like to know whether anyone else using DDE has had issues with an XML 2003 Spreadsheet Markup Language compliant file.

cynthia

Re: error "The converter failed to save the file."

wkossack_nspirehealth_com — Tue, 12 Mar 2013 17:38:18 GMT

Ah I noticed something....

I could open the file on my PC but on the windows SAS server it would not

XML was set to open with an xml editor not excel. This problem is now fixed