I have an excel file with 3 or 4 different sheets having Hyperion Data. I need these to refresh through a macro instead of clicking on the HYPERION tab and then clicking on REFRESH ALL. Any ideas?

In another thread, I had asked to update my access connections (DATA TAB then REFRESH ALL) and the answer was to add the line: 

ActiveWorkbook.RefreshAll
Will this also work for the Hyperion refresh or is there another line of code? I am assuming there is because to refresh another add-in (LiveOffice) I needed to add the line: 

Application.COMAddIns(1).Object.liveObjects.Refresh True
Any help would be appreciated. I am on a deadline and once this is solved, I should be able to fly though it!