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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Citrix XenApp, Internet Explorer 11 set to Enterprise Mode and using central hosted sites.xml file.
While working, an annoying popup showing below will come and we cannot cancel or close it form the screen. The error message will come again and again.
Google currently has a new report that is in beta and coming soon to Webmaster Tool accounts. This Micro Tutorial will highlight new features for Google Webmaster Tools.
This Micro Tutorial will demonstrate how nuggets on the Web are formatted by using Chrome Developer Tools. These tools would not only view the site's CSS but it can also modify it and save the CSS to use on your own site.

937 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

Need Help in Real-Time?

Connect with top rated Experts

1 Experts available now in Live!

Get 1:1 Help Now