Solved

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

Posted on 2014-12-16
1
13,251 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

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

When you start your Windows 10 PC and got an "Operating system not found" error or just saw  "Auto repair for startup" or a blinking cursor with black screen. A loop for Auto repair will start but fix nothing.  You will be panic as there are no back…
In threads here at EE, each comment has a unique Identifier (ID). It is easy to get the full path for an ID via the right-click context menu. However, we often want to post a short link within a thread rather than the full link. This article shows a…
In this Micro Tutorial viewers will learn how to use Boot Corrector from Paragon Rescue Kit Free to identify and fix the boot problems of Windows 7/8/2012R2 etc. As an example is used Windows 2012R2 which lost its active partition flag (often happen…
This Micro Tutorial will give you a basic overview of Windows Live Photo Gallery and show you various editing filters and touches to photos you can apply. This will be demonstrated using Windows Live Photo Gallery on Windows 7 operating system.

615 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