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-com
fficeffice" /><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>
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-com
fficeffice" /><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>
