oBar.Controls("Hyperion").Controls("Refresh All").Execute

[Irek1974]

Hi,

I used such a code which worked with Excell 2003 with not problems:

Sub refr()
Dim oBar As CommandBar
Set oBar = Application.CommandBars("Worksheet Menu Bar")
oBar.Controls("Hyperion").Controls("Refresh All").Execute
End Sub

but sometime ago our IT dep updated Smart View in Hyperion because they installed Excell 2010 on our computers.
From that moment the code above doesn't work.

could anyone help please ?
regards,
I.

 

[RoryA]

Where is the button now?

 

[Irek1974]

sorry for a delay
this button is now in Smart View.
I can send to you print-screen if you give me an email address or tell me how to do it in this tag

Where is the button now?

 

[RoryA]

Try opening up the Customise Quick Access Toolbar dialog, change the dropdown to show all commands, then locate and hover the cursor over the 'Refresh All' button (if it appears in the list) and tell me what the tooltip text says at the end.

 

[Irek1974]

and when I could find this "Customise quick access toolbar dialog" ?
is it somewhere in Excel ?( I use excel 2010)

Try opening up the Customise Quick Access Toolbar dialog, change the dropdown to show all commands, then locate and hover the cursor over the 'Refresh All' button (if it appears in the list) and tell me what the tooltip text says at the end.

 

[RoryA]

Right click the Quick Access Toolbar (above the Ribbon).

 

[Irek1974]

actually I have two "Refresh All" buttons.
the first one : Essbase|Data|Refresh All (CustomControl)
the second : Smart View|Data|Refresh All (CustomControl)

I hope this helps

Right click the Quick Access Toolbar (above the Ribbon).

 

[RoryA]

Oh - I think you might be out of luck then, unless there is something in the Accessibility objects that will allow it. I will have a play and see.

 

[RoryA]

Is Smart View a new tab, or a group on an existing tab? I would need to know:
Tab name
Group name
Caption

I think, in order to be able to click it.

 

[Irek1974]

Smart View is a new tab (like "main menu", "insert", "formulas", "data" or "view", "delevloper", "additions"

when I click on Smart View I see :
- Start (Open)
- Edit (undo, redo, copy data point, paste data point, Functions)
- Data (Refresh button (it has two opitons: refresh , refresh all), Data submit)
- general (options, help, sheet info, more)

Is Smart View a new tab, or a group on an existing tab? I would need to know:
Tab name
Group name
Caption

I think, in order to be able to click it.