03-11-2013 05:13 PM
I create a spreadsheet with
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?
03-11-2013 09:18 PM
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.
03-12-2013 01:38 PM
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