VBA dp refresh solution please

[norty303]

Hi. I've got a short bit of VBA that someone kindly provided from another forum but it doesn't run giving an error:

runtime error 91

Object variable or with block variable not set


The code is:

Private Sub Document_Open()
DIM ThisDocument as Document
ThisDocument.DataProviders("YourDPNameHere&quot.Refresh
End Sub



As I'm unfamiliar with VBA I'm unable to debug it. Can anyone here help. It's purpose is to refresh just one DP in the report on open.

Many thanks

 

[nimmy99]

If you would like to refresh you document, use this way
Set Doc = ActiveDocument
Doc.Refresh

 

[Sridharan]

Norty,

You cannot get a reference to the ActiveDocument in the Document Open event since the Document is yet to opened and made active. Check out this code and it should get you what you are after..

Private Sub Document_Activate()
    ActiveDocument.DataProviders.Item(1).Refresh
End Sub

The above code will refresh the 1st DP when the document is opened.

Regards,
Sri