Macro for "Retrieve" in Essbase Menu
 

When retriving Essbase using macro, if there are other text in the
sheet(other than the essbase's own formatting), warning msg will pop-up
everytime. Is there any ways to disable these pop-ups which will
disturb the retrieving? Tks!

Macro for "Retrieve" in Essbase Menu
 

wrote:
When retriving Essbase using macro, if there are other text in the
sheet(other than the essbase's own formatting), warning msg will pop-up
everytime. Is there any ways to disable these pop-ups which will
disturb the retrieving? Tks!

Dear raizwai,

Use the following code at the beginning of your macro code
Application.DisplayAlerts = False

Use the Following code at the end of your macro code
Application.DisplayAlerts = True

Regards
Thyagaraj