'Cause I'm such a nice guy , here's a quick and dirty Python script I wrote a while ago for a mate of mine... Dunno if he still uses it...

It gets all the worksheets for the day and writes the favourites to a spreadsheet. Note, it is a quick and dirty script, there is no error checking, and if it has a problem with something it raises an exception and closes (default Python behaviour)

If you want to try it out you will need to install Python - get it from http://www.python.org - get 2.7 not 3.x - it is not compatible and pywin32 (for the excel stuff) from http://sourceforge.net/projects/pyw...win32/Build216/ - select the right version to match the version of Python you've got.

Anyway, it shows what can be done.

Attached Files

get_rands.zip (1.9 KB, 1314 views)