Hello

I was hoping you could help me. *I am looking to build a spreadsheet that automatically opens a pre-defined link in internet explorer depending on what year, month, date and time it is.*

Imagine that I have only two entries in my spreadsheet, one column has a date and time information and the other has a weblink:

12/12/2010 17:30 | www.bbc.co.uk*
12/12/2010 18:00 | www.cnn.com

So if the time was between 17:30 and 17:59 on 12 December 2010, when I open the worksheet I should automatically be taken to www.bbc.co.uk. *Similarly, if the time is past 18:00 or later on 12 December 2010, when I open the worksheet, I should automatically be taken to www.cnn.com.

The actual spreadsheet will have hundreds of entries, so I am looking for a way of automating this process. *Any suggestions would be welcome!

Thank you for all your help.