Archive for the ‘desktop’ Category


When you can’t use MS Excel Web Query

Author: Oliver Phillips, Tuesday, December 23, 2008

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 [...]

Tags: , - Posted in desktop, scripting | No Comments »


Need a Timer in Excel?

Author: Oliver Phillips, Friday, November 28, 2008

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 [...]

Tags: , - Posted in desktop | No Comments »