error "The converter failed to save the file."

[wkossack_nspirehealth_com]

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?

[Reeza]

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

[Cynthia_sas]

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

[wkossack_nspirehealth_com]

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