Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2014-12-16
1
Medium Priority
?
13,813 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 2000 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Assume you have an outside contractor who comes in seasonally or once a week to do some work in your office, but you only want to give him access to the programs and files he needs and keep all other documents and programs private. Can you do this o…
IF you are either unfamiliar with rootkits, or want to know more about them, read on ....
This Micro Tutorial will give you a introduction in two parts how to utilize Windows Live Movie Maker to its maximum capability. This will be demonstrated using Windows Live Movie Maker on Windows 7 operating system.
This Micro Tutorial will demonstrate how to add subdomains to your content reports. This can be very importing in having a site with multiple subdomains.
Suggested Courses

660 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