Alerts on Changes to Workbooks?

T

The Message

My problem is this. I have an identical workbook currently saved on two
independent LANS's. They have no connection or linkage at all. What I want,
is an alert or email that there have been changes made on one of the
workbooks, so I can make the corresponding changes to the other. My
application does not allow me to use the 'discussion' function. Is there any
way this can be done?
 
A

Atishoo

If its not too large you could send the entire workbook by email each time
its saved:

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
ActiveWorkbook.SendMail Recipients:="Jimmy Page"

End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top