Hello All,
We use the Essbase Excel Addin. Essbase replace nulls and blanks with a value of the user's choice, but if zero is used, Essbase places a text zero instead of the numeric zero. This causes problems and I wrote a bit of code to find and replace the data. The challenge is finding or creating an event for when Essbase completes the retrieve. I can, and have, written code where a button is clicked, Essbase updates and then the replace occurs, but I hope to have the code present in all my worksheets to avoid needing a special button for retrieving data. I'd prefer to use the current menu functionality.
Can anyone help me with this challenge?
We use the Essbase Excel Addin. Essbase replace nulls and blanks with a value of the user's choice, but if zero is used, Essbase places a text zero instead of the numeric zero. This causes problems and I wrote a bit of code to find and replace the data. The challenge is finding or creating an event for when Essbase completes the retrieve. I can, and have, written code where a button is clicked, Essbase updates and then the replace occurs, but I hope to have the code present in all my worksheets to avoid needing a special button for retrieving data. I'd prefer to use the current menu functionality.
Can anyone help me with this challenge?
