Menu

Macro for "Retrieve" in Essbase Menu

Search this Thread

Prev

Previous Post

Next Post

Next

#2

Report Post

Posted to microsoft.public.excel.programming

Thyagaraj

Thyagaraj is offline

external usenet poster

Posts: 51

Default

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

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Hyperion Essbase Excel Add-in - returning text ("0") for null valu	bill_morgan	Excel Discussion (Misc queries)	7	February 28th 12 05:10 AM
Lost "File Menu" - now it's "Edit / View / Insert.." but no "F	daves	Excel Discussion (Misc queries)	3	April 24th 07 04:52 AM
Macro for "Retrieve" in Essbase Menu	[email protected]	Excel Programming	1	July 27th 06 04:17 PM
CommandBars("Worksheet Menu Bar").Controls("Tools").Enabled = Fals	Arturo	Excel Programming	3	May 26th 05 05:44 PM
Macro for "Retrieve" in Essbase Menu	Jelso	Excel Programming	1	September 11th 03 09:12 AM

All times are GMT +1. The time now is 05:46 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement