MS Excel Web Query is one of my favourite bits of kit, I used it extensively when I worked in Finance, and I still use it regularly at eantics Ltd for some applications. It basically lets you bring data off a web page and use it in your workbook. That could be internet, intranet, or [...]

For some Excel applications, you might want a timer so that a routine can run every so often.  You could send your VBScript macro into an eternal loop, and check the time with each cycle - but that’s quite processor intensive.
You can create a timer using web queries.  These have a built in auto refresh [...]