Macro to convert decimal separators from US to EU format when loading a CSV file?

To accommodate a number of clients who run Excel with German locale settings and need to open CSV files that contain US formatted data, I am looking for a way to write a macro that automates the various steps to make this switch (the "problem" here is that the decimal separator is a period in the US and a comma in Germany whereas the thousand separator is a comma in the US and a period in Germany). Without changing the setting, the data is not recognized properly.

Is it possible to combine the following steps in a macro - all of it or portions of it?

-In Excel 2010, select Data, then "From Text" in "Get External Data"
-It opens a file selection window; select the CSV file you want to open, click "Import"
-For file origin, select "65001: Unicode (UTF-8)" - click next
-leave "Tab" as the delimiter and click next
-click "Advanced" and select the comma for decimal separator and period for thousand separator - click finish

The idea here is to get this macro to the clients so they can run it instead of the steps above every time the want to open a file with US formatted data.

Thanks Chippy, super helpful.
Just to get the final step right: what portion of the recorded macro do I need to replace with Application.GetOpenFilename? Or is it: call Application.GetOpenFilename

Here are the first few lines:

With ActiveSheet.QueryTables.Add(Connection:= _
"TEXT;C:\Users\kgrossmann\Desktop\kwd20.csv", Destination:=Range("$A$1"))
.Name = "kwd20"
.FieldNames = True
.
.
.

Works like a charm,
thanks Chippy!