Failed to Find Office Control by ID TabNew;FileSaveAs;FileOpen

Hi,
I am using the following ribbon XML to hide options in the backstage menu for Excel 2010 - 2013

Please Login or Register  to view this content.

This works fine with Excel 2010, but with 2013 (when clicking on the File menu) 3 errors are displayed:

Failed to Find Office Control by ID TabNew
then
Failed to Find Office Control by ID FileSaveAs
then
Failed to Find Office Control by ID FileOpen

According to this link it should work in 20120 & 2013:
http://www.rondebruin.nl/win/s2/win005.htm

I cannot fathom why I have this problem.

Richard

In 2013 TabNew is TabOfficeStart, FileSaveAs is TabSave and Open is TabRecent. I don't think you should see the errors unless you have your options set to display CustomUI errors (which is not the default).

If you check the ExcelControl IDs for 2013 those are not present.

Check that page again and look at the 2013 items. You will see for example FileSaveAs is now called TabSave.

The real problem is that 2010 and 2013 share the same namespace although the mso information is not the same.

Hi Andy,
if there some way then that I can have an if-then-else in the xml to do-this if 2010 and do-this for 2010?

Not that I know of.

No solution then? I guess I can't disable the error checking either..

Originally Posted by romperstomper

In 2013 TabNew is TabOfficeStart, FileSaveAs is TabSave and Open is TabRecent. I don't think you should see the errors unless you have your options set to display CustomUI errors (which is not the default).

Hi
please could you tell me how to set CustomUI errors?
That sounds promising!

I don't think it's exposed to VBA (it's a registry setting controlled by the ReportAddinCustomUIErrors DWORD entry) but I think your Ribbon XML would be validated before you could do anything about it in code anyway.

Maybe you could adopt this approach. Where you have multiple versions of the UI to be loaded.
http://msmvps.com/blogs/xldynamic/ar...me-simple.aspx

BTW the UI setting for errors is within the Advanced section of Excel Options. As romperstomper says this is not exposed to the OM.

Thanks
I could set the registry setting on App-Load, however I can't actually find it in the registry.
This page talks about this for Access:
http://social.msdn.microsoft.com/For...orum=accessdev

But the key mentioned is not in the registry on my PC
ReportAddinCustomUIErrors
HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Common\General\

Must be in there somewhere!

It's only created the first time you turn that setting on, I suspect. (of course you need 15.0 not 12.0 for Office 2013)

Ah yes - I was looking under 14 - silly me.
Thanks all

Yep - changing the setting on app load worked a treat.
Cheers

Glad to help.

BTW, you may want to be a little more careful in future when repping people to make sure you give them positive rep and not negative.

oops very sorry!

Not to worry - I knew what you meant.