HFM system 9.0 retrieves and Excel macro
649318Jul 9 2008 — edited Jun 16 2009We run HFM system 9. I have several retrieves that I use as reports. I need to run these reports for several sites (change various points of view) and would like to use a macro in Excel to accomplish this.
I haven't been able to get it to work. The macro can change the points of view, but when I refresh the query (via visual basic code that accesses the menu in excel), the macro continues to the next line of code without waiting for the retrieve to refresh.
Could someone explain how to do this?
Also, is there a visual basic function available when I am running system 9 smartview to call a refresh directly from code without having to go through the excel menu?
Thanks.