want to auto-run a macro every 5 minutes but not lock up com

jleslie48 · Mar 27th, 2002, 02:29 PM

it seems simple enough, but I can't seem to locate any info on this. I want to run a
macro, say "foo", every 5 minutes. if the
macro is not running, I would like to be able
to shrink excel, work on the spreadsheet, basically do anything I want. Any Ideas?

Thanks in Advance,

Leslie

DMeador52 · Mar 27th, 2002, 02:43 PM

There may be an easier way (possibly using DoEvents) but I would say that this is easily done by making a quick Visual Basic exe that controls Excel.

You can link to the open workbook every 5 minutes and run the macro quite easily.

dk · Mar 27th, 2002, 02:52 PM

Have a look at the Ontime method in VBA help. There are examples which show you how to do this. If you need any help with it then please repost.

regards,
Dan

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 27th, 2002, 02:29 PM	#1
jleslie48 New Member Join Date: Mar 2002 Posts: 11	it seems simple enough, but I can't seem to locate any info on this. I want to run a macro, say "foo", every 5 minutes. if the macro is not running, I would like to be able to shrink excel, work on the spreadsheet, basically do anything I want. Any Ideas? Thanks in Advance, Leslie

Mar 27th, 2002, 02:43 PM	#2
DMeador52 New Member Join Date: Mar 2002 Posts: 32	There may be an easier way (possibly using DoEvents) but I would say that this is easily done by making a quick Visual Basic exe that controls Excel. You can link to the open workbook every 5 minutes and run the macro quite easily.

Mar 27th, 2002, 02:52 PM	#3
dk MrExcel MVP Join Date: Feb 2002 Location: Sydney, Australia Posts: 2,908	Have a look at the Ontime method in VBA help. There are examples which show you how to do this. If you need any help with it then please repost. regards, Dan