| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro for "Retrieve" in Essbase Menu
On the Essbase menu Select Options- Global tab and change the Warning
settings. These settings can be changed through code also if you wish. They are global settings (as opposed to sheet level settings) which will be in effect for every retrieve that you perform on every sheet. -- HTH... Jim Thomlinson " 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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hyperion Essbase Excel Add-in - returning text ("0") for null valu | Excel Discussion (Misc queries) | |||
| Lost "File Menu" - now it's "Edit / View / Insert.." but no "F | Excel Discussion (Misc queries) | |||
| Stop users from accessing "Protection" option from "Tools" menu | Excel Programming | |||
| CommandBars("Worksheet Menu Bar").Controls("Tools").Enabled = Fals | Excel Programming | |||
| Macro for "Retrieve" in Essbase Menu | Excel Programming | |||
Linear Mode
