Hi, I have a macro that has always worked perfectly. It copies data from a CSV file (lets say a particular column has the value 40.00 in it) and my excel is happy with it and can do calculations.
I have a colleague in the Netherlands who I've just shared this with and when it imports the data, it just cannot understand what 40.00 is. If I manually change this to 40,00 (European comma format) then it's happy days.
My question is - how do I ask VBA.. "If my user is English then keep the dot. If he is Dutch then replace the dot with a comma"
I can do the replace part but I don't know how to check if it actually needs replacing? thanks, John
Bookmarks