Clicking a ribbon button with VBA?

Is it possible to access a tab on the ribbon and click a certain button? I have an add-on in Excel which I would like to call, but do not know how to do it directly with VBA, is it possible to perform the equivalent of clicking a certain button on the ribbon with vba?

Thanks

JYTS,

I'm guessing yes; but I'm not experienced enough to guide you how. Have you attempted to record a macro, click the certain button on the ribbon and view the code that is generated? If that works, please post the code that did it because I'd like to see it.

Here is something I found really quickly that may point you towards the correct methods and objects you'll need to play with to approach your solution, even though this does not directly address the problem you'd like to solve:
Taken from an msdn.microsoft website:

https://social.msdn.microsoft.com/Fo...s?forum=isvvba

Recording a macro does not work. I'll look at the link....

Originally Posted by shg

What button are you looking to click?

I'm trying to click a refresh workbook in the FactSet tab.

Does that do something more than the following?

Please Login or Register  to view this content.

Hi and sorry for the delay. It is a button on an add-on called Factset, and the button is labeled "Refresh." It is not a query table, it is a button on an add-on in the ribbon. It can be reached with Alt+S+R+W if that helps .... (maybe I'll look into pressing keys with VBA and see if that is possible.....)