kdsanderson30
New Member
- Joined
- Jun 12, 2014
- Messages
- 17
I am not GREAT at Macros, so I will try and explain what I need the best I can.
We have a workbook that has a macro already with a Live Clock that calculates the job times etc. It is on a Server for remote access and used by many people 1 at a time. I look in the file at the data to send intervention emails regarding the times etc. The problem, is that the user does not SAVE the file but every couple of hours so I am not seeing live data. We cannot force a save without a pop up of sometimes, which would be the best bet, but I am unsure how to do that.
Another option is to Autosave a backup file every so many minutes that I could view remotely and use to send the intervention emails without disturbing their copy. Any ideas?
We have a workbook that has a macro already with a Live Clock that calculates the job times etc. It is on a Server for remote access and used by many people 1 at a time. I look in the file at the data to send intervention emails regarding the times etc. The problem, is that the user does not SAVE the file but every couple of hours so I am not seeing live data. We cannot force a save without a pop up of sometimes, which would be the best bet, but I am unsure how to do that.
Another option is to Autosave a backup file every so many minutes that I could view remotely and use to send the intervention emails without disturbing their copy. Any ideas?