Visio automatic data refresh when the file opens

Started by kren1986, March 31, 2015, 10:57:03 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

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

#1
It will be something like that with a macro.
There is maybe a command to refresh all datarecordset in one line
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