Hi All

I have a workbook with numerouse MDX queries. To refresh everything I can just hit the refreshall button and wait ... to code this I can code the refreshall. What I want to do is automate this and then close the workbook. The problem is detecting when the sheet(s) have finished the updates. Has anyone any ideas how to figure out when the mdx has completed the updates.
Note the code line of refreshall runs through but the application continues to update all the cells with MDX in them
Thanks
Phil

I have a workbook with numerouse MDX queries. To refresh everything I can just hit the refreshall button and wait ... to code this I can code the refreshall. What I want to do is automate this and then close the workbook. The problem is detecting when the sheet(s) have finished the updates. Has anyone any ideas how to figure out when the mdx has completed the updates.
Note the code line of refreshall runs through but the application continues to update all the cells with MDX in them
Thanks
Phil