Main Area and Open Discussion > General Software Discussion

script to notify for specific excel cell values

(1/1)

kalos:
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:
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!
-kalos (March 17, 2015, 09:54 AM)
--- End quote ---

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:

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.

Navigation

[0] Message Index