New to this site. Would like a some advice on VBA in Excel for Hyperon Essbase. I have written a macro to step through the tabs in a large workbook and do a retrieve on each tab. The macro is working well. But I would like to have the macro to turn off the Flashback feature, do the retrieves (For next loop) then turn the Flashback back on.
Declare Function EssMenuVRetrieve Lib "ESSEXCLN.XLL" () As Long
Declare Function EssMenuVFlashBack Lib "ESSEXCLN.XLL" () As Long
Sub loop_all_sheets()
‘
‘ Disable Essbase Flashback????
‘
' Retrieve Detail Sheets
For y = 4 To 21
Sheets(y).Select
Range("A1:A1").Select
Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select
x = EssMenuVRetrieve
Next y
‘
‘ Enable Essbase Flashback?????
‘
End Sub
Declare Function EssMenuVRetrieve Lib "ESSEXCLN.XLL" () As Long
Declare Function EssMenuVFlashBack Lib "ESSEXCLN.XLL" () As Long
Sub loop_all_sheets()
‘
‘ Disable Essbase Flashback????
‘
' Retrieve Detail Sheets
For y = 4 To 21
Sheets(y).Select
Range("A1:A1").Select
Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select
x = EssMenuVRetrieve
Next y
‘
‘ Enable Essbase Flashback?????
‘
End Sub