Creating a macro that can be used in Essbase Hyperion

Resolved · High Priority · Version 2003

Fri 6 Aug 2010, 11:25 Delegate Sarah said...

Sarah has attended:
Excel VBA Intro Intermediate course

Creating a macro that can be used in Essbase Hyperion

Hi
I work with a lot of spreadsheets which i need to manually update every month via Essbase Hyperion

I do not know what codes will need to be used to run a macro that automatically refreshes data in essbase for multiple worksheets
Please help
Thanks
Sarah

Mon 9 Aug 2010, 14:09 Trainer Jacob said...

RE: Creating a macro that can be used in Essbase Hyperion

Hello Sarah

Thanks for your post. We might be able to assist but would certainly need to have access to your working files and for one of us to have a conversation with you on what you are trying to achieve with this other application.

This sort of work is beyond the scope of this forum and if you would like to discuss this further please reply to my email.

Kind regards

Jacob

Mon 16 Aug 2010: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Excel tip:

Use the Format Painter to copy formatting more than once in Excel

The format painter tool provides a quick and easy way to copy formatting from one cell to another in Word.

The only problem is that if you click the Format Painter once to turn it on, you can only click and drag over a single cell or adjacent range of cells; then the Format Painter turns itself off automatically.

If you want to copy formatting to cells or groups of cells that are not adjacent to each other, double-click the Format Painter - this way you will be able to copy formatting to multiple cells.

When you have finished using Format Painter, press the Esc key or click on the Format Painter button once to turn it off.

View all Excel hints and tips