Discussion:
Repeat command every 5 min.
(too old to reply)
Igor G.
2010-02-10 14:45:02 UTC
Permalink
How to repeat this macro every 5 min.?
Thanks!

Sub SaveAsJPG()
Application.ActiveWindow.Page.Export "C:\pView.jpg"
End Sub
AlEdlund
2010-02-10 15:50:47 UTC
Permalink
put in a timer control (standard vb(a)) and have it fire off every five
minutes.
al
Post by Igor G.
How to repeat this macro every 5 min.?
Thanks!
Sub SaveAsJPG()
Application.ActiveWindow.Page.Export "C:\pView.jpg"
End Sub
Igor G.
2010-02-10 18:59:02 UTC
Permalink
Can you give me code for this?
Thanks.
Post by AlEdlund
put in a timer control (standard vb(a)) and have it fire off every five
minutes.
al
Post by Igor G.
How to repeat this macro every 5 min.?
Thanks!
Sub SaveAsJPG()
Application.ActiveWindow.Page.Export "C:\pView.jpg"
End Sub
AlEdlund
2010-02-10 19:33:46 UTC
Permalink
http://www.tushar-mehta.com/excel/software/vba_timer/
Post by Igor G.
Can you give me code for this?
Thanks.
Post by AlEdlund
put in a timer control (standard vb(a)) and have it fire off every five
minutes.
al
Post by Igor G.
How to repeat this macro every 5 min.?
Thanks!
Sub SaveAsJPG()
Application.ActiveWindow.Page.Export "C:\pView.jpg"
End Sub
Loading...