View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Atishoo Atishoo is offline
external usenet poster
 
Posts: 267
Default Alerts on Changes to Workbooks?

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

"The Message" wrote:

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?