Excel VBA decimal separation
Posted on 2011-09-08
I am a relative novice in Excel VBA and would therefore appreciate some assistance.
I have some excel VBA that is effectively creating from an excel sheet a structured XML file for import into an ERP system.
The XML standards imparted by the vendor mean that it will only accept a (.) decimal separator and not a (,) comma decimal separator.
This becomes a problem when my users in Germany populate the Excel sheet as their locale is set to use (,) comma decimal separator.
I therefore wondered if it was possible via the Excel VBA to do a find and replace on these values before creating the XML, if the decimal separator in the Excel sheet was set to comma (,)??....
Any thoughts would be greatly appreciated as always.