View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jacob_F_Roecker
 
Posts: n/a
Default The worst Code Ever

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.