![]() |
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