Hello,
I am 'learning by doing' .net programming for excel macros, i.e. I am not an advanced user. I have been trying to solve a problem for quite some time.
The issue is regarding an add in called Essbase, which is an excel environment for viewing BI data (Hyperion system 9). A cube is exported from the application which is then read from Essbase in Excel.
It works quite much like a pivot table only that here you refresh by double clicking the sheet.
When creating reports I have been using a macro to sort data. The user then has to refresh the data manually by double clicking.
My question now is:
How can I integrate the double clicking procedure in the excel sorting macro? I have been trying the
Worksheets("Sheet1").Activate
Application.DoubleClick
Suggested in the tutorials which, suposedly should be equivalet to doublleclicking the sheet. This, however does not seem to work for the Essbase environment.
Thank you all in beforehand for some usefull help ón this problem.
Regards
Jonas