ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Macro affecting hyperion retreive (https://www.excelbanter.com/excel-programming/358073-macro-affecting-hyperion-retreive.html)

Jim May

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




All times are GMT +1. The time now is 11:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com