C
Chutney
I have an Excel 2007 workbook used by several individuals. I need to
send an email with the user's name whenever a user makes a change and
saves the file. I have a working process that prompts the user to save
the file when they close it and, if they choose yes, will send an
email (based on Ron de Bruin's code.) However, I need a couple of
enhancements:
1. Capture the name of the user and add it to the email.
2. If a user saves the file before closing it, trap that act and run
the email routine before saving the file.
I would prefer not to Share the file but if that is necessary in order
to get the user's name then I can do that. If I do turn on sharing
then I would like to include the changes made as well as the user's
name in the email.
I searched this group but could not find any reference to this issue
so I would appreciate any assistance.
send an email with the user's name whenever a user makes a change and
saves the file. I have a working process that prompts the user to save
the file when they close it and, if they choose yes, will send an
email (based on Ron de Bruin's code.) However, I need a couple of
enhancements:
1. Capture the name of the user and add it to the email.
2. If a user saves the file before closing it, trap that act and run
the email routine before saving the file.
I would prefer not to Share the file but if that is necessary in order
to get the user's name then I can do that. If I do turn on sharing
then I would like to include the changes made as well as the user's
name in the email.
I searched this group but could not find any reference to this issue
so I would appreciate any assistance.