How to run an excel macro automaticaly in 5 in 5 minutes? Is that possible?
F Fernando Mar 9, 2009 #1 How to run an excel macro automaticaly in 5 in 5 minutes? Is that possible?
M Michel Petit Mar 9, 2009 #2 Yes, you can. The following line will run the macro "Sicuta" one minute after execition. Application.OnTime Now + TimeValue("00:01:00"), "Sicuta"
Yes, you can. The following line will run the macro "Sicuta" one minute after execition. Application.OnTime Now + TimeValue("00:01:00"), "Sicuta"
D Dave Peterson Mar 9, 2009 #3 I'd start with Chip Pearson's site: http://www.cpearson.com/excel/OnTime.aspx (Every 5 minutes, right?)
I'd start with Chip Pearson's site: http://www.cpearson.com/excel/OnTime.aspx (Every 5 minutes, right?)
F Fernando Mar 10, 2009 #5 Thank you Michel! "Michel Petit" escreveu: Yes, you can. The following line will run the macro "Sicuta" one minute after execition. Application.OnTime Now + TimeValue("00:01:00"), "Sicuta" Click to expand...
Thank you Michel! "Michel Petit" escreveu: Yes, you can. The following line will run the macro "Sicuta" one minute after execition. Application.OnTime Now + TimeValue("00:01:00"), "Sicuta" Click to expand...
