Hyperion Excel Add-In and Macro

M

Marmaduke810

New Member
Joined
Nov 25, 2009
Messages
1
I am trying to write a macro to pull all Essbase queries in an Excel file. The tricky part is some of the queries are on the same tab but have to be pulled in different databases. I have been unsuccessful in creating a macro to pull from different databses on the same tab as well as other tabs in the file all with different ranges. Help!
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
You must log in or register to reply here.

Similar threads

N
  • Question
Double Click Macro that creates new sheet using SQL query
Replies
1
Views
118
Fluff
Fluff
V
  • Question
Looking to create VBA command to go through List of sheet names, look up sheet name in range, look up value in cell next to it, and run a macro
Replies
3
Views
100
Volrin
V
S
  • Question
Multiple Use Radio or Checkmark Buttons
Replies
2
Views
103
ScottTemple
S
L
  • Question
How to Determine If Donating to One Cause Led to Long-Term Donating?
Replies
4
Views
200
LPax11
L
R
  • Question
Is there a way to open a file that Power Query has locked as Read-Only?
Replies
0
Views
88
rcrumbliss
R

Forum statistics

Threads
1,214,812
Messages
6,121,693
Members
449,048
Latest member
81jamesacct

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top