Visio automatic data refresh when the file opens

[kren1986]

HI evryone!

I have a visio drawing with several data connections to the sharepoint lists included. I would like to configure that all data connections in my visio drawing would be automatically refreshed when user opens the drawing (so the trigger for the refresh wouldn t be a "refresh all" button click but opening a document). Is that posible to configure and how to configure this?

Tanks for your answers.

Žiga

[lindir]

It will be something like that with a macro.
There is maybe a command to refresh all datarecordset in one line

Code Select Expand

Private Sub Document_DocumentOpened(ByVal Doc As IVDocument)

'On parcourt et actualise les datarecordsets
    For i = 1 To ThisDocument.DataRecordsets.Count
           ThisDocument.DataRecordsets(i).Refresh
    Next i
End Sub