View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Keithlo Keithlo is offline
external usenet poster
 
Posts: 62
Default Essbase Add-In Functions

I am working with macros written by a former employee, and these macros do
essbase retrieves with the following code:

Declare Function EssMenuVRetrieve Lib "ESSEXCLN.XLL" () As Long
Declare Function EssMenuVDisconnect Lib "ESSEXCLN.XLL" () As Long
Declare Function EssMenuVConnect Lib "ESSEXCLN.XLL" () As Long
Declare Function EssMenuVOptions Lib "ESSEXCLN.XLL" () As Long

X = EssMenuVRetrieve

My question is this: Are these functions part of the Essbase Add-In? I
assume they are. And how do I learn about these functions so that I can use
them in my code. Mosly I would like to know how to have Essbase Zoom in one
level, or Zoom in through all levels.

Also, wouldn't the code "EssMenuVRetrieve" (without the "X =") accomplish
the same thing as "X = EssMenuVRetrieve"? Forgive my ignorance, I've written
many sub routines, but never really used functions before.

Any help will be greatly appreciated.

Thanks!

Keith