Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Alerts on Changes to Workbooks?
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Alerts | Excel Discussion (Misc queries) | |||
Worksheet Alerts | Excel Discussion (Misc queries) | |||
alerts | Excel Worksheet Functions | |||
Display Alerts | Excel Discussion (Misc queries) | |||
Alerts? | New Users to Excel |