Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error message every time I run a macro

2850450Jun 11 2015 — edited Jun 18 2015

Hi,

I built this macro to auto refresh within SmartView. Every time I run these two macros while using SmartView I get this error. Can someone help me out?

Macro error.JPG

These are the two Macros I am using:

Private Sub Workbook_Open()

Dim Confirm As Variant

Confirm = MsgBox("Would you like to refresh?", vbQuestion + vbYesNo, "Please confirm")

If Confirm = vbNo Then Exit Sub

Call HypMenuVRefreshAll

curWorksheet = ActiveSheet.Name

x = HypRetrieve(curWorksheet)

If x = 0 Then

    MsgBox ("Retrieve successful.")

Else

    MsgBox ("Retrieve failed.")

End If

End Sub

and

Sub refreshWS()

Run "refreshWS"

End Sub

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 16 2015

Added on Jun 11 2015

#business-intelligence-applications, #financial-consolidation, #performance-management-applications, #smartview

4 comments

674 views