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

Yes that is all Essbase stuff. To find out more in Excel Click on Help -
Essbase Help - Index - EssGet... to find out more about all of the
functions that you can use...

In terms of the x that will hold the return value of the function. The
majority of the functions that you will be using the return value will
indicate the success or failure of that funtion. For example if the
EssVConnect function is successful then it iwll return a 0 otherwise it will
return some other number. You should always check the return values to see fi
the funciton completed successfully or not. All of the Examples in the help
do not check the return value...

In terms of doing zoom in or any of those other functions they are covered
in the help EssVZoomIn...
--
HTH...

Jim Thomlinson


"Keithlo" wrote:

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

This is most helpful. Exactly the answer I needed. Thank you so much!

Keith

"Jim Thomlinson" wrote:

Yes that is all Essbase stuff. To find out more in Excel Click on Help -
Essbase Help - Index - EssGet... to find out more about all of the
functions that you can use...

In terms of the x that will hold the return value of the function. The
majority of the functions that you will be using the return value will
indicate the success or failure of that funtion. For example if the
EssVConnect function is successful then it iwll return a 0 otherwise it will
return some other number. You should always check the return values to see fi
the funciton completed successfully or not. All of the Examples in the help
do not check the return value...

In terms of doing zoom in or any of those other functions they are covered
in the help EssVZoomIn...
--
HTH...

Jim Thomlinson


"Keithlo" wrote:

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