Turn OFF : Do You Want To Open or Save This File in IE

Posted on 2014-12-16
Last Modified: 2014-12-25
How can this be turned OFF : Do You Want To Open or Save This File in IE (when opening Excel File)
IE 9

Question by:mvalencia2003
1 Comment

Accepted Solution

Francois_IT earned 500 total points
ID: 40503326
Your solution is here:

(Extract from: )

1.In Internet Explorer 10 or 11 you will first have to click on a file of the type you want to open automatically next time.
 2.This will give you the Open/Save prompt.
 3.Select the Save option.
 4.Then in Internet Explorer click Tools
 5.Under Tools click the View Downloads option
 6.You will see a popup containing the file that you just downloaded.
 7.Right-click on the file
 8.In the options presented, make sure to un-check the option labeled: Always ask before opening this type of file
From now on if you click on a file of that type, the file will bypass the automatic prompt and will open automatically.
Configuring the Open/Save for a File Type using a Batch File
I have tried several ways of updating a computer’s setting. Bottom line in this case is that this setting requires an update to the Windows Registry. If you made your file type preference changes as described in the manual way of doing things above, then the way that this works is by writing your preference directly to the windows registry.
By the way, if you are not familiar with making registry updates, then you probably shouldn’t be trying this out. You can really mess up your machine by making incorrect registry updates if you aren’t careful.
Steps to Take
So how are we planning to identify and update the correct entry in the Windows Registry? For starters, you’ll need to find out what the key that you need to add is for the file type that you are working with. In this example I’m showing a key that codes for automatically opening .RDP files. However, in your case you will have to specify exactly what file type you want to enable on people’s machines.
The path in the Windows registry where Internet Explorer saves this information is:


Changes to this location will update your current user settings. So if you create a batch file for users to run, it will update their personal settings.
Getting the right key that needs to be set is another matter entirely. I was able to get the correct key as follows:
 1.Open the Registry (type regedit into a command prompt for example)
 2.Browse to the registry hierarchy (as shown above) and try to browse to the AttachmentExecute key… if it doesn’t exist, then don’t worry… it will be created when you make the file open/save update
 3.Take note of the keys already in the AttachmentExecute key. You may want to take a before/after screen capture to reference later.
 4.Close the registry.
 5.Now open Internet Explorer and go through the steps to manually permit the automatic opening of the file type that you are interested in (as explained earlier in this article)
 6.Open the Registry again
 7.Browse to the registry heirarchy and browse to the AttachmentExecute key
 8.You should now see that a new sub-key has been added.
 9.In the case of an RDP file this sub-key is: {0002DF01-0000-0000-C000-000000000046}
 10.The sub-key has a value in it that specifies the file type to permit.
 11.Again, in the case of an .RDP file the value is a REG-NONE type with the name RDP.File and with data set as 0 (null)
 12.Again, make sure to see exactly what the system automatically entered for you. This will let you know how to script your batch file
 13.Write this down to help with the following steps of creating your batch file commands.

Scripting your Batch File
 1.Create a new batch file (for example: abc.bat)
 2.Edit the batch file in your favorite editor such as Notepad
 3.Enter the following lines of code, and then adjust the path and sub-key values based on the notes you took in the steps above.

reg query HKEY_CURRENT_USER\Software\Microsoft\Windows\Shell\AttachmentExecute\{0002DF01-0000-0000-C000-000000000046}
if "%ERRORLEVEL%" EQU "1" (
reg add "HKEY_CURRENT_USER\Software\Microsoft\Windows\Shell\AttachmentExecute\{0002DF01-0000-0000-C000-000000000046}" /f /v "RDP.File" /t REG_NONE

The first command queries the path to see if it exists. In this case it queries the full path needed for .RDP files. For other file types such as .PDF files, this path will vary in the unique key number created under AttachmentExecute.
 1.If the path is not found, the an error level value of 1 will be returned (note… a value of zero means the path was found).
 2.If an error level of 1 returns for the path, then we need to create a new registry entry to allow documents to be automatically opened.
 3.Use the Reg add command to create the new registry path and key values.
 4.As you can see, in this reg add command we add the path of …\AttachmentExecute\{0002DF01-0000-0000-C000-000000000046}
 5.And we add the key named RDP.FILE with a REG_NONE type and null data
Final Steps
 1.When you have finished putting together your batch file, save it.
 2.Then open your registry and delete the key {0002DF01-0000-0000-C000-000000000046} from your registry if it exists.
 3.Now run the batch file as an administrator
 4.Open your registry again and make sure that your batch script has properly duplicated creation of the registry key that Internet Explorer automatically made for you in the above steps.
 5.If the registry entry looks good, then try clicking the link to the file type of your choosing in Internet Explorer. If everything went correctly, then you should no longer be prompted to Open/Save the file… it should open automatically.
If you have trouble with any of the batch file commands, you can always open a DOS command prompt and run the help file for that command. For example for help with the reg add command, type reg add /? and you will see the full list of options. A search engine search can also return helpful results.

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
2013 Outlook has e-mails, but no calendar or contacts 4 29
What are all these files on my C drive? 5 41
stopping group policy 6 28
application access evidence windows 7 5 30
OfficeMate Freezes on login or does not load after login credentials are input.
When you try to share a printer , you may receive one of the following error messages. Error message when you use the Add Printer Wizard to share a printer: Windows could not share your printer. Operation could not be completed (Error 0x000006…
This Micro Tutorial will teach you the basics of configuring your computer to improve its speed. It will also teach you how to disable programs that are running in the background simultaneously. This will be demonstrated using Windows 7 operating…
How to create a custom search shortcut to site-search Experts Exchange using Google in the Firefox browser. This eliminates the need to type out whenever you want to search the site. Launch your Bookmark Menu: Press 'Ctrl +…

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question