I am using Excel to download and process data from Yahoo, f.ex.

The code I use is
.....
Workbooks.Open Filename:=s1 + Range("D4") + pcode
+CStr(Range("Settings!G25")) + s3
Cells.Copy
Windows(MyWindow).Activate
Sheets("HistoryData").Cells.Select
Sheets("HistoryData").Paste
.....

Filename resolves to f.ex.
http://ichart.yahoo.com/table.csv?s=...86&ignore=.csv

This works fine for me, but on computers with Regional Settings that
specify "," as decimal symbol there is a problem. All data are put in
a single column.

Is there any way to temporarily change the decimal symbol setting?

Thx.
Lester