Alerts on Changes to Workbooks?

  • Thread starter Thread starter The Message
  • Start date Start date
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?
 
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

Similar Threads

Sharing workbooks limitations - Merged Cells 12
Disable Macro Alert 2
Merge Multiple workbook sheets into one workbook 0
Turn off Excel alert 1
Macro to push data to another workbook 0
Conditional Date Alert 1
Repeat alert, "No more new fonts may be applied to this workbook" 3
Alerts.... 4

Back
Top