I'm new to VB and trying to learn for a specific project - I've done plenty of VBA (although not for a year or two) in the past but that's my limit. I'm helping to manage some equipment which adds a new record to a csv log file every 15 mins. Whenever the value in the fourth column in that log changes to or from 0 (regardless of what it changes to or from), I want to fire an email off (two different emails - one for the value changing to 0 - i.e. turning off, and a different email for it changing from 0 - i.e. turning on). Can anyone point me in the right direction for some code for that?
I've been looking around for two days (at utilities as well as VB code) and haven't got any further than this thread:
thanks in advance!