Data source types:Essbase, Planning, Financial Management, Hyperion Enterprise
HypRetrieveAllWorkbooks() refreshes all open workbooks from the same instance of Excel.
HypRetrieveAllWorkbooks()
Returns 0 if successful; otherwise, returns the appropriate error code.
Declare Function HypRetrieveAllWorkbooks Lib () As Long
Sub Sample_HypRetrieveAllWorkbooks()
X=HypRetrieveAllWorkbooks()
End Sub