Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-23-2012, 01:57 AM
Eruditio Eruditio is offline How to change BrowserFlags for ExcelViewer subkey in regedit? Windows XP How to change BrowserFlags for ExcelViewer subkey in regedit? Office 2010 32bit
Novice
How to change BrowserFlags for ExcelViewer subkey in regedit?
 
Join Date: Jul 2012
Location: UK
Posts: 1
Eruditio is on a distinguished road
Default How to change BrowserFlags for ExcelViewer subkey in regedit?


First of all, I realise there are a fair few related questions on many other sites, in addition to Microsoft Support pages. I have spent many hours on this issue, and this is where I stand and what I know/have been able to achieve:
  • I have an application written in Visual Basic Express 2010
  • There is an AxWebBrowser control in the main form
  • On computers with Excel 2010 installed (and running Windows XP), I've managed to get it working fine; I realised that I needed to change the registry so that the Excel documents would open within the AxWebBrowser instead of in a separate Excel window (see this Windows Support page)
  • On computers with Excel Viewer installed (and running Windows 7), the Excel documents continue to open in a separate Excel Viewer window
  • On the computers with Excel Viewer installed, there are eight additional registry subkeys with the names: ExcelViewer.Macrosheet.8, ExcelViewer.Sheet.12, ExcelViewer.Sheet.8, ExcelViewer.SheetBinaryMacroEnabled.12, ExcelViewer.SheetMacroEnabled.12, ExcelViewer.Template.12, ExcelViewer.Template.8, ExcelViewer.TemplateMacroEnabled.12
  • The fix given in on the aforementioned Windows Support page requires adding a new key in four subkeys (for Excel, not ExcelViewer) via "BrowserFlags"=dword:80000A00
  • I realise this value is a hexadecimal value. In regedit the Data value for these keys is 0x80000a00 (2147486208)
  • The hexadecimal value is different for Word, PowerPoint, and Excel in the aforementioned fix
I therefore assume there is a particular hexadecimal value I need in order to stop the Excel documents opening in a separate Excel Viewer window on those computers on which it is installed. I've tried using the Excel value 0x80000a00 in just .Sheet.8, .Sheet.12, .SheetMacroEnabled.12, and .SheetBinaryMacroEnabled.12, as per the fix for Excel. I've also tried putting it in all eight subkeys. None of this has worked, so I can only assume I need a different hexadecimal value.

I've scoured the net for a possible list of values that would help me with this, but to no avail. It seems this sort of information is kept under wraps. So now I'm appealing to all of you (and I hope this is the right section of the forum) in the hopes that somebody can provide a solution or at least point me in the right direction.

Let me make it clear that I don't believe the issue to be anything to do with how I've implementing the AxWebBrowser in VB 2010. I included that information as background information. I also don't think it's an issue with Windows XP compared to Windows 7. I've read many Windows Support pages for help with this issue and nothing seems to address the problem of Excel Viewer specifically. My last port of call, I suppose, would be to guess registry values. The largest hex value I've seen for BrowserFlags with respect to Microsoft Office products is 0x80000a00 for Excel. Even if I were to guess every value between 0x80000000 and 0x80000a00, there would be around 2500 values and a tedious week of work.

Many thanks for even reading this far - I realise that was quite a dense question. Any help would be greatly appreciated.
Reply With Quote
Reply

Tags
browserflags, excel viewer, registry



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to change BrowserFlags for ExcelViewer subkey in regedit? How do I change default cinque8 Word 5 06-08-2012 11:18 AM
if letter change font also change gsrikanth Excel 1 05-15-2012 03:03 AM
How to change BrowserFlags for ExcelViewer subkey in regedit? How to change save location and file to print name change? albertc Excel Programming 1 05-13-2012 07:05 PM
How to change BrowserFlags for ExcelViewer subkey in regedit? change the view to final, my change bars disappear. I need them visible anna.a.julin Word 1 03-01-2012 08:05 PM
"Change Word Options" don't change ADKREV Word 0 11-12-2010 10:56 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:52 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft