Essbase VBA question

[Johnmu]

Hi All,

I have some VBA code that retrieves data from Essbase. Once I use the macro to retrieve the data I can't use flashback to restore the previous view. The message I get it that there is no flashback information for this sheet.

From the Oracle site I see how to declare Flashback but I cannot see how to Enable Flashback .. Can anyone help me with this please??

Thanks

John

EssVFlashBack(sheetName)<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o></PRE>
ByVal sheetName As Variant<o></o></PRE>Parameters<o></o>
sheetName<o></o>
Text name of worksheet to operate on. sheetName is of the form "[Book.xls]Sheet". If sheetName is Null or Empty, the active worksheet is used.<o></o>
Return Value<o></o>
Returns 0 if successful. A negative number indicates a local failure (see VBA Return Values). A return value greater than zero indicates a failure on the server.<o></o>
Example<o></o>

Declare Function EssVFlashBack Lib "ESSEXCLN.XLL" (ByVal sheetName As Variant) As Long<o></o></PRE>
<o> </o></PRE>
Sub FB()<o></o></PRE>
X=EssVFlashBack(Empty)<o></o></PRE>
End Sub<o></o></PRE>