T
Toni Miletic
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!
)
Kind regards
Toni
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!
)Kind regards
Toni