Hi,

I've got a shared workbook (legacy) that different machines & users use. I have setup 1 PC to operate in the background which has the workbook open at all times, as it automates reports & sends emails at specific times. The issue I have is when it calls my code for saving to update with the latest data from other users, I get the question to accept others changes or keep mine. Is there a piece of code that will allow me to automate the selecting of Allow Others at this stage? The PC in the background will be locked as part of the domain policies in place.

I fully know where the issue is as there is a cell that puts todays date in using the =Today() method. Obviously when a user opens their version of the workbook up after midnight each day the date both PC's have is different so the conflict arises as the cell value is different. I should point out that I need the latest date to display so when the lookups works they select the current days data.

The other method I'm trying to work on is closing the workbook before midnight then reopening it after midnight so it updates the date.

Any suggestions would be appreciated.