Emailing XML direct from Excel

[Guest]

Please help! I have a problem with Excel 2003 and Excel 2002 where if I open
an XML Spreadsheet file in Excel and then select File - Send To - Mail
Recipient as Attachment, Excel converts the XML to XLS before attaching it.

Is there someway I can make Excel leave the document alone so that XML gets
sent on? I need to open XML, allow changes to cells, save changes and send
as XML to be further parsed etc.

This works fine if the XML is opened in Internet Explorer (Excel 2003 only)
but not in Excel itself.

 

[Guest]

Could someone please test and tell me if this is happening for them too or
whether it is just me. create simple document in Excel 2003 or 2002 and
save it as XML Spreadsheet. Select File=>Send To=>Mail Recipient (as
Attachment) and see if the attachment is XML or XLS.

 

[Dave Peterson]

The attachment was .xls for me, too (using xl2003).

Can you just save the file as .xml, then close that workbook, then send that
file as an attachment.

You may find some useful stuff at Ron de Bruin's site--depending on the email
client you're using.

http://www.rondebruin.nl

 

[Guest]

Thanks for the reply Dave. Yes I could do that (and we are) but the
convenience of simply having the user make his changes and hit Send To is too
good to let go if we can help it. I did the same experiment in Word and it
doesn't have the bug. If you create an XML in word, that's what gets
transmitted, attached to the email. Word does not convert XML into a *.DOC
file so why does Excel convert XML into *.XLS files!?

 

[Dave Peterson]

I think the technical reason is: 'Cause that's the way excel works.

(That's a question to ask the developers at MS.)