| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Comma-delimited files and Reional Settings
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Saving as tab delimited or comma delimited | Excel Discussion (Misc queries) | |||
| Tab delimited to comma delimited | Excel Worksheet Functions | |||
| Comma Delimited-need comma at beginnng & end | Excel Discussion (Misc queries) | |||
| Comma Delimited Numbers | Excel Discussion (Misc queries) | |||
| How do I turn off autoformat for .CSV (comma delimited) files? | Excel Discussion (Misc queries) | |||
Threaded Mode
