Thread: [Solved] Auto date alarm?
View Single Post
 
Old 11-18-2009, 07:22 AM
markg2 markg2 is offline Windows 7 Office 2007
Expert
 
Join Date: Nov 2009
Location: Evergreen, CO
Posts: 344
markg2 is on a distinguished road
Default

I inserted and tested your suggestion number one and it works as advertised--thanks.

However, I have a need that may exceed the ability of Excel. I do not often open this spreadsheet. The number of companies listed is roughly 40, their dates of contact are mostly staggered and the time between re-contact is generally greater than 90 days. Therefore, although the script works fine once the spreadsheet is opened, while Excel is closed the script is of no help.

What I REALLY need is for the script to 'wake-up' (load) the spreadsheet or place an alert on the desktop or in some way to tell me to open and check the spreadsheet. Is such a mechanism out of the realm of reason?

Thanks,

Mark
Reply With Quote