Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Smartview Command Control Execution Error

Sounak_CFeb 12 2014 — edited Feb 12 2014

Hi Experts,

I am not sure if this is the right forum to ask this question but just wanted to check if anyone else has faced a similar issue.

I am using SmartView to refresh data from HFM and then use a lot of custom macro codes for analysis. Since, I had a lot of spreadsheets to refresh, I had used the following code(not excatly similar) to automate the refresh all process

Set obar = Application.CommandBars("Worksheet Menu Bar")

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

This worked fine till we moved to Excel 2010. I have searched most of the Excel forums and the sense I am getting is it is no longer possible to execute 3rd party command controls in this new "Ribbon" version.

Would someone please confirm this as I think this is a fairly common functionality and was used by a lot of people.

Regards,

This post has been answered by Erich Ranz on Feb 12 2014

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 12 2014

Added on Feb 12 2014

#business-intelligence-applications, #financial-consolidation, #performance-management-applications

1 comment

1,229 views