amarkle
05-14-2012, 04:01 PM
We have a document in our office that contains all of our company vehicles and who is currently assigned to them (driving them).
The workbooks are set up by month, with the sheets being each day of the month.
Multiple people have access to edit this information.
We also have a GPS application that we enter this information to for speed tracking purposes.
I am looking to have an email sent to me whenever information is changed in the workbook.
I have spent hours searching Google and have tried multiple VBA codes and forums looking for an answer/code that works.
I am new to VBA codes and have absolutely no clue what I'm doing, so I will also need simplified instructions on how/where to put this code in.
If anyone can solve this issue, the office would thank you. We have a huge problem with our GPS assignments not matching our excel list, because people do not update the GPS database.
I am using Excel 2003 and Outlook 2003.
I have attached a copy of one of our list for anyone that would like to give it a go - since nothing seems to work for me.
8062
Thank you!
The workbooks are set up by month, with the sheets being each day of the month.
Multiple people have access to edit this information.
We also have a GPS application that we enter this information to for speed tracking purposes.
I am looking to have an email sent to me whenever information is changed in the workbook.
I have spent hours searching Google and have tried multiple VBA codes and forums looking for an answer/code that works.
I am new to VBA codes and have absolutely no clue what I'm doing, so I will also need simplified instructions on how/where to put this code in.
If anyone can solve this issue, the office would thank you. We have a huge problem with our GPS assignments not matching our excel list, because people do not update the GPS database.
I am using Excel 2003 and Outlook 2003.
I have attached a copy of one of our list for anyone that would like to give it a go - since nothing seems to work for me.
8062
Thank you!