Trying to create a macro that is able to go within an installed add-in

Hello all,

First, let me state that I am a beginner in terms of VBA language and macros but let me attempt to explain what I am trying to do in Excel 2007.

I want to record/create a macro that goes to a specific add-in tab and within the specific addin tab, refreshes the entire worksheet (via the add-in).

So for example, I use an Add-in that I pull historical data from. In order to update this historical data (the manual way), I have to open excel, click over to the actual add in tab, and then click refresh, then refresh entire workbook (an option within this particular add-in). What I want to do, is be able to just click a button that does these three manual steps for me each time.

If I am still somewhat unclear, its almost similar to recording a macro that would go and click file-print each time I click a button (instead of having to manually click file-print) (and I am able to do this). However, my button will not work when I try to record it, going within another add-in.

Hope this makes sense and thanks for the help.