Chip Pearson has lots of instructions at:
http://www.cpearson.com/excel/ontime.htm

Jacob_F_Roecker wrote:

OK I think that I've got the record for the WORST code EVER.

I wanted to build a spreadsheet that would automatically become a webpage.

I built the macro and I was good. COOL BEANS

But I wanted excel to do that every minute...because it referenced a
external data that updated every minute.

I got it to work the WORST possible way you could imagine for code and speed.

I told it to calculate the difference between two cells--each of which were
times/dates.

Basically my Macro is continuously running the =now() on one cell until it's
been a minute and then it runs the other code.... starts all over and does it
again.

I KNOW there are more efficient ways of doing this but google didn't point
me to anything I could understand.

Someone mind writing me and letting me know the BEST way to do this? I'm
game for some reading.

--

Dave Peterson