Run macro in Visio 2007 every 5 min.

Hints, tips and tricks for newbies

Moderators: Dorian (MJT support), JRL

Post Reply
zerp
Newbie
Posts: 5
Joined: Mon Nov 30, 2009 10:24 pm

Run macro in Visio 2007 every 5 min.

Post by zerp » Wed Feb 10, 2010 10:11 pm

How to first run macro in Excel and wait to refresh data,
after that run macro in Visio 2007... repeat this operation every 5 min.?
Excel and Visio files can be always opened.
Thanks!

Explanation...
I have Visio file linked to Excel and every 5 min. must saving Visio file with refreshed data like jpg picture.

wjfinniganjds
Junior Coder
Posts: 24
Joined: Tue Sep 15, 2009 3:20 pm

Multiple Macros?

Post by wjfinniganjds » Mon Apr 26, 2010 6:56 pm

Hi,

How will it know when to stop?
I think I can automate that!

adroege
Automation Wizard
Posts: 438
Joined: Tue Dec 07, 2004 7:39 pm

repeat operation every 5 min

Post by adroege » Tue May 18, 2010 10:43 pm

repeat this operation every 5 min.?
Label>Loop

... your macro lines go here
...
...
//300 seconds is 5 minutes
Wait>300
Goto>Loop

Post Reply
Sign up to our newsletter for free automation tips, tricks & discounts