Auto Refresh and DataRecordsetChangedEvent

Started by lindir, November 20, 2014, 08:52:20 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

lindir

Hello,

I have a code to run after the datarecord is refresh.
I do it with this :

Private Sub DataTRS_DataRecordsetChanged(ByVal DataRecordsetChanged As IVDataRecordsetChangedEvent)

SeqEncours
MsgBox "DataRecord changed and Routine was launch"
End Sub


The problem is that when I click manually in Data and Refresh the All the data, everything is working fine, but when I set the parameter of the dataTRS recordset to refresh every minute, the datarecord set get refreshed but the macro isn't launched...

Any idea guys??

Thanks in advance,

Alex

lindir

UP!

Nobody know why the event doesn't trigger the routine??

AN other solution would be to find a way to launch a macro every X minutes.

I tried this :
http://msdn.microsoft.com/en-us/library/office/ff196165(v=office.15).aspx

But Application. On Time method doesn't seem to work on Visio.


Thanks for your help :)