Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Emailing XML direct from Excel
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. |
#2
|
|||
|
|||
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. "Ne1" wrote: 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. |
#3
|
|||
|
|||
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 Ne1 wrote: 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. "Ne1" wrote: 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. -- Dave Peterson |
#4
|
|||
|
|||
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" wrote: 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 Ne1 wrote: 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. "Ne1" wrote: 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. -- Dave Peterson |
#5
|
|||
|
|||
I think the technical reason is: 'Cause that's the way excel works.
(That's a question to ask the developers at MS.) Ne1 wrote: 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" wrote: 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 Ne1 wrote: 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. "Ne1" wrote: 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. -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
Emailing an Excel worksheet | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |