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.