Results 1 to 11 of 11
  1. #1
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Lawrence, Kansas, USA
    Posts
    202
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Settings for file extensions (IE 6)

    I frequently download csv files. On my desktop, I have unchecked the box that asks "Would you like to open the file or download it to your computer?" On that machine, it opens a spreadsheet in the browser. On my new laptop, the box is greyed out and It asks every time. I've been looking through the security settings and helper extensions, but can't figure where this is.

    Thanks for any pointers you can give.

  2. #2
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Long Beach, California, USA
    Posts
    1,912
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Settings for file extensions (IE 6)

    It is under Folder Options | File Types | CSV file (or whatever it might be called) | Edit | Confirm Open After Download.

  3. #3
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Lawrence, Kansas, USA
    Posts
    202
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Settings for file extensions (IE 6)

    Thanks. Folder options isn't the most obvious name for changing file options!

  4. #4
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Long Beach, California, USA
    Posts
    1,912
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Settings for file extensions (IE 6)

    What?? You expected Windows to be logical? What planet are you from? <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    Cheers.

  5. #5
    Super Moderator
    Join Date
    Dec 2000
    Location
    Renton, Washington, USA
    Posts
    12,560
    Thanks
    0
    Thanked 4 Times in 4 Posts

    Re: Settings for file extensions (IE 6)

    "Folder options isn't the most obvious name for changing file options"

    Where would you put it to be more useful?

    Now running HP Pavilion a6528p, with Win7 64 Bit OS.

  6. #6
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Lawrence, Kansas, USA
    Posts
    202
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Settings for file extensions (IE 6)

    I kept looking for something in the internet options to change the settings for the helper applications. I also looked under My Computer properties. But since it's a general application setting, it might make sense to have it under Add/Remove Programs. There is a Change button and something to set software options in that utility, so it makes sense to have it there.

    I couldn't find anything in the Help files, but sometimes that's not unusual.

  7. #7
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Lawrence, Kansas, USA
    Posts
    202
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Settings for file extensions (IE 6)

    I changed the setting for the file extensions, but IE still asks every time if I want to open or save the file. The box - Always ask before opening this type of file is greyed out. I want it to I just open, not ask every time.

    I suspect that its probably some security setting, but I've gone through the list of internet settings. I don't see anything obvious.

    My older desktop just opens the file in IE.

    Thanks for your additional help.

  8. #8
    Super Moderator
    Join Date
    Dec 2000
    Location
    Renton, Washington, USA
    Posts
    12,560
    Thanks
    0
    Thanked 4 Times in 4 Posts

    Re: Settings for file extensions (IE 6)

    Go back in to Windows Explorer, Tools, Folder Options and then the File type tab. Scroll down to CSV and select, click the Advance button and clear the check mark in front of "Confirm open after down load".

    Now running HP Pavilion a6528p, with Win7 64 Bit OS.

  9. #9
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Lawrence, Kansas, USA
    Posts
    202
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Settings for file extensions (IE 6)

    Thank you. Sorry for being so dense. I see that R2 had those instructions also. Maybe it will sink in now.

  10. #10
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Long Beach, California, USA
    Posts
    1,912
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Settings for file extensions (IE 6)

    It might be more complicated than that -- if you are still having trouble. (This gets a little technical, so excuse me).

    Here are the registry associations on the computer that I am using (not mine):

    .csv -> Excel.CSV -> Microsoft Excel Comma Separated Values File
    CLSID = {00020820-0000-0000-C000-000000000046}
    Shell/open/command = "C:Program FilesMicrosoft OfficeOfficeexcel.exe" /e

    Now, that CLSID (class identifier) is for "Microsoft Excel Worksheet" -- and it is the same CLSID used for the .xls files. So, at some point, .csv files are going to be treated just like .xls files.

    Furthermore, this computer has NO "Content Type" entry under the .csv -- so, this computer does not tell IE to do anything with CSV files. The Content Type value is stored under the file extension key (HKCR/.csv) and is used to specify a MIME Content Type for Internet Explorer. IE uses this information to know how to process a given file type.

    You may need to look under "HKEY_CLASSES_ROOT/.csv" to clarify what the Content Type for your .csv files have been defined as.

    If you find "application/vnd.ms-excel", then IE is going to handle your .CSV files EXACTLY as if they were .XLS files. THEREFORE, the Folder Options | File Type you are looking for, is going to be "Microsoft Excel Worksheet".

    On the other hand, if your .csv files have a unique MIME Content Type, then you need to look for that specific File Type in the Folder Options box.

    Sorry I cannot be more specific -- this computer does not have .csv files associated with any MIME Content Type. If you can't figure this out, could you please at least use regedit to identify what the Content Type of your .csv file are? (I can walk you through ANYTHING, so don't hesitate to ask HOW.)

  11. #11
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Long Beach, California, USA
    Posts
    1,912
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Settings for file extensions (IE 6)

    OK, this is a work in progress -- and at a very early stage -- but if you have no idea what I am talking about, run the attached .vbs file and it will get a lot of information out of the registry for you. You simply have to enter "csv" (no quotes) in the Input box, then write down the results. This should give us the information we need.

    Of note, the more I think about this, the more I suspect that modifying the "File Types | Confirm open..." box may not help you. It all depends on whether or not you have a MIME Content Type setting for the .csv file extension.

    I you have no MIME Content Type listed, then it should work as expected. However, if the MIME Content Type for .csv files is the same as .xls files, then things might not work as expected...
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •