Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 430
Default Macro affecting hyperion retreive

In changing our Hyperion s/w over to another server,
our IT has told us (users) that if errors occur they are
due to Macros being present in our active excel file (??&^%&^%)... and if
present, we must perform some additional work,, modification having to do
with re-selecting the members..(??) - in order to fix..

Someone asked me, "how do I know if I have a macro?" From the standpoint of
"ease" and in that order I said you could begin determining that by:

From any open current excel file (in order of ease - and note that first
couple do not guarantee you don't)..
1) From Spreadsheet - do Alt+F8 - Only Partial answer
2) From Spreadsheet - do Alt+F11 - Get to the Project Explorer window and
double-click on a) each sheet object, b) the ThisWorkbook object and ) any
Standard modules
3) While in VBE - Project Window there of course can be 1) a Personal.xls;
or 2) Other Currently Open Workbooks; 3) Various AddIns..

After that, I'm not sure what to offer.
Any advise on what else should be considered here.

Any Help appreciated,
Jim


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Macro, shortcut keystroke for Hyperion Add-In [email protected] Excel Discussion (Misc queries) 0 May 2nd 07 01:58 AM
Range Name affecting speed of macro Richard Buttrey Excel Worksheet Functions 5 May 1st 06 03:06 PM
Hyperion Essbase add-in macro Ctech[_57_] Excel Programming 2 December 29th 05 05:14 PM
Macro for Hyperion muthu Excel Worksheet Functions 0 December 10th 05 07:22 AM
Macro to connect excel sheets automatically to Hyperion ESSBASE 6.5 mcm Excel Programming 0 August 29th 03 10:44 AM


All times are GMT +1. The time now is 04:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"