I have a series of Excel 2003 spreadsheets with data that I need to load to a corporate Hyperion Database, one by one.
I can automate the submission of spreadsheets using the following "Hyperion submission code"
And then can automatically proceed from spreadsheet to spreadsheet repeartng the "Hyperion submission code"
until all data is submitted
Unfortunately after submitting Speadsheet#1 and before proceeding to Spreasheet#2 there is a pop up message (I believe this is generated by our corporate Hyperion server)
"The data has been successfully saved and associated Business Rules run"
together with an "OK" button
After manually selecting "OK" the macro poceeds to spreasheet#2 and so on
I understand the purpose of popup messages but would love to be able to procced from spreadsheet to spreadsheet without needing to manually select "OK"
Can I disable these popup messages ? or alternatively is there a way to automate the selection of "OK" ?
Bookmarks