Hi
I want to supress no data fetch message. I used the the following code in VBA
Private Sub Document_BeforeRefresh(Cancel As Boolean)
Application.Interactive = False
End Sub
Private Sub Document_AfterRefresh()
Application.Interactive = True
End Sub
But this code supress prompt also. I want the prompt intact.I want to achieve in the VBA level