Hi,

I have a spreadsheet where I have to select a macro button to run a
macro that will automatically update the data in the spreadsheet from a
text file that is being updated every 15 minutes by my company's MRP
system.

Two questions:

1) - Can someone give a novice some detail directions as to how I can
get this to update the file automatically when the file is opened and
perform a save? Then I wouldn't need the button.

2) - The harder question. I've been searching the Google groups for a
way of having an automatic E-mail sent out to an E-mail address or even
up to 5 recipients whenever a cell with a formula changes to a certain
response, e.g. when cell V168 goes to "Actg to Roll Cost", send an
E-mail to someone in Accounting instructing them that they have an
action to perform. I want the information in a adjacent cell in that
row to appear in the E-mail along with the information in cell V168. I
know that if I click on an E-mail address that's typed into a cell, our
Lotus Notes E-mail program will automatically address an E-mail to that
person. However, I want this to go out without my having to even know
that something has changed this value. I'm looking at several columns
of data where I want to act on any cell change in those columns
accordingly. I hope I've explained this right. I have seen links to
"www.rondebruin.nl/mail/change.htm" that probably explain this, however
I'm not quite savy enough to understand how to make that work for my
situation....

Regards,

Steve