Solved

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

Posted on 2014-12-16
1
11,206 Views
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


Thanks
-
0
Comment
Question by:mvalencia2003
1 Comment
 
LVL 6

Accepted Solution

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

(Extract from: http://jwcooney.com/2014/03/31/remove-internet-explorer-open-or-save-popup/ )

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:

 HKEY_CURRENT_USER\Software\Microsoft\Windows\Shell\AttachmentExecute\

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.

 @ECHO OFF
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.
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

This article offers some helpful and general tips for safe browsing and online shopping. It offers simple and manageable procedures that help to ensure the safety of one's personal information and the security of any devices.
New Windows 7 Installations take days for Windows-Updates to show up and install. This can easily be fixed. I have finally decided to write an article because this seems to get asked several times a day lately. This Article and the Links apply to…
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…
Shows how to create a shortcut to site-search Experts Exchange using Google in the Chrome browser. This eliminates the need to type out site:experts-exchange.com whenever you want to search the site. Launch the Search Engine Menu: In chrome, via you…

706 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

18 Experts available now in Live!

Get 1:1 Help Now