Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
XML export form a Excel
Dear all,
I use Office 2003 XML Tool Addin for exporting from Excel 2003 sheet fields to XML file. I've created XML schema to some fields in my Excel sheet. Then I've created macro to export those fields in XML file. Everything is working fine for me except decimal separator. In Excel and on my system I have "," as decimal separator but after creating XML file I get "." as decimal separator. Part of the macro code that I used is: "file$ = "K:\share\" & Cells(4, 3) & "_1_" & year & month & day & ".xml" ActiveWorkbook.XmlMaps("report_Map").Export URL:= _ file$ " Do you know how I could force it to use "," as decimal separator also in XML export. Thanks in advance for your help! :o) Kind regards Toni |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Export as XML for an Excel Order form document | Excel Discussion (Misc queries) | |||
export a form | Excel Programming | |||
Export data from excel to IE form | Excel Programming | |||
Pleeze Help! Export Excel data into a form in a Word Doc...this one's tough! | Excel Discussion (Misc queries) | |||
How can I export data from an Excel form into an external Excel d. | Excel Discussion (Misc queries) |