Home | Blog | Software | Reviews and Features | Forum | Help | Donate | About us
topbanner_forum
  *

avatar image

Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
  • September 29, 2016, 05:08:28 PM
  • Proudly celebrating 10 years online.
  • Donate now to become a lifetime supporting member of the site and get a non-expiring license key for all of our programs.
  • donate

Author Topic: script to notify for specific excel cell values  (Read 874 times)

kalos

  • Member
  • Joined in 2006
  • **
  • default avatar
  • Posts: 1,454
    • View Profile
    • Donate to Member
script to notify for specific excel cell values
« on: March 17, 2015, 09:54:54 AM »
hello!

I was thinking of a script
a web script, an AHK script, a macro inside the excel file, not sure yet
that will monitor a specific cell and notify if it is still empty after 5 days or if it is still empty after 14/04/2015, etc
is that possible?

thanks!

TaoPhoenix

  • Supporting Member
  • Joined in 2011
  • **
  • Posts: 4,548
    • View Profile
    • Donate to Member
Re: script to notify for specific excel cell values
« Reply #1 on: March 17, 2015, 10:58:23 AM »
hello!

I was thinking of a script
a web script, an AHK script, a macro inside the excel file, not sure yet
that will monitor a specific cell and notify if it is still empty after 5 days or if it is still empty after 14/04/2015, etc
is that possible?

thanks!

When is it supposed to notify you? When you open the excel file or "whenever" like some external popup when you are doing something else?

Seems like the second case is a little harder because the page wouldn't be actively be in processing as an application, though it can't be impossible. Layman-pseudo-guess from me would be something like speed-opening the file just to run scripts and closing it again, though that could get a little weird on comp processing delays at odd seeming times.


TaoPhoenix

  • Supporting Member
  • Joined in 2011
  • **
  • Posts: 4,548
    • View Profile
    • Donate to Member
Re: script to notify for specific excel cell values
« Reply #2 on: March 17, 2015, 11:00:50 AM »

Presuming it's in-file, another layman-guess is that you do a conditional if statement on another cell so that it goes something like "if (today-OtherDate) > X AND if cell = empty, then Y other cell becomes "Alert" else "Safe".

Then you just do some kind of action that makes sure formulas refresh in the file such that if it's just sitting there in a file while you're working it checks like maybe every six hours.