Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Error opening a CSV from Web Browser after changing Region
We generate CSV files from our web application and most people can
access them from Internet Explorer no problem (Excel starts within an IE window). However, some users in Denmark have reported that Excel does not load, all that happens is that the IE window appears briefly then disappears. I have done some testing and found that if I change my Regional Settings to Danish, it fails in the same way. However, if I then reset back to English, it still fails, even after a reboot. These are the symptoms:- 1) When region is Danish, saving a CSV file locally and double-clicking it within Windows Explorer causes Excel to start but puts all data into a single column. I understand that as the list separator for the Danish region is ";" and not ",". 2) If I create a HTM file locally that references the CSV file as a link, this still works as above as long as I open the HTM file from Windows Explorer (ie. it is not http but a file name instead) 3) If I then copy the HTM file and CSV file to a local Virtual Directory and open the HTM file in Internet Explorer using http://localhost/VirtDir/myTest.htm and then click the link, it fails by quickly displaying a blank IE window and then closing. I have ideas on how to lookup the users Region and set the correct delimeter in the CSV file but have no idea why the file will not open in Internet Explorer over HTTP. Even worse, I cannot get them to work even when I revert to English so my PC is out of action for all CSV files. Any ideas please? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Launch new browser window from hyperlink within Excel | Excel Worksheet Functions | |||
Changing format of number without changing the value | Excel Discussion (Misc queries) | |||
Open Excel in a browser without changing URL | Excel Discussion (Misc queries) | |||
How do I stop excel automatically changing my date to 2005? | Excel Discussion (Misc queries) | |||
launching xls in web browser | Excel Discussion (Misc queries) |