How do I fix this custom ADM so that it will work, or apply this setting through another method.

I am attempting to set a registry value through group policy, so that when an excel file is opened through a browser it will definitely spawn in a new window.

So far I have identified the registry key.

Windows Registry Editor Version 5.00

@="Microsoft Excel Worksheet"

Im not sure if the @ part is needed, but as a .reg this will work.

Then I have attempted to make a .adm file to use group policy to apply this setting.  I am aware that I cannot set HKEY_CLASSES_ROOT values with a .adm, so I am applying it to HKEY_LOCAL_MACHINE\Software\Classes\Excel.Sheet.8

The .adm I have so far is below, however I am new to the syntax and whilst this parses correctly when loaded into the GP editor, it doesnt give any settings.  What changes should I make to get this to work?


      POLICY "Excel Open File Settings Fix"
      KEYNAME "Software\Classes\Excel.Sheet.8"
            PART "Open In Same Browser Window"
            VALUENAME "BrowserFlags"
            DEFAULT "00000008"
            END PART

Cheers for any help
Adam BeardmoreAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

You need to go to the View > Filter menu in the GP editor and uncheck "Only show policies that can be fully managed"; you will then see the policy you created in red instead of the standard blue.
Note that this is not a real policy, it's a "preferred setting" or "tattooing" of the registry. This change will *not* "go away" or be reset to a former/default value if you remove the policy, it will stay on the last value applied as if you changed the registry manually. And should you ever decide to remove the adm file from the GPO, edit the GPO first and set this back to "Not configured"; only then remove the adm file. If you remove the adm file while the setting is stil active, it will still be in the GPO, but you won't be able to change it anymore.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Adam BeardmoreAuthor Commented:
Fantastic thanks for your help!

I realised that it is the same as a manual registry edit, we are sure that this is a setting we would like permanently.

I'm really surprised that my syntax was correct, I was almost certain I had the statements in the wrong order or something...


Adam BeardmoreAuthor Commented:
Thankyou very much for the swift help.
Adam BeardmoreAuthor Commented:
Further to all of the above.  While the solution helped me apply the .adm, I found it didn't function as expected.  I did a bit more research into syntax and have made this one instead, in case somebody wants to use the code.  This has been tested to work on Windows 2k SP4 and XP Pro SP3 workstations.


      KEYNAME "Software\Classes\Excel.Sheet.8"      
      POLICY "Set Excel Open New File Preferences."
      EXPLAIN "Enabled will force the opening of excel files in new windows (no embedded spawn from IE).  Disabled will enable the embedding."
                  KEYNAME "Software\Classes\Excel.Sheet.8"
                        VALUENAME "BrowserFlags"
                        VALUE NUMERIC 8
                  KEYNAME "Software\Classes\Excel.Sheet.8"
                        VALUENAME "BrowserFlags"
                        VALUE NUMERIC 0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows Server 2003

From novice to tech pro — start learning today.