Update a shared workbook.
 

Does anyone know how I can update a shared workbook that resides on
network drive in order that multiple users who have it open can se
other people's changes?

The worksheet is populated by way of a form which enters the data i
the next blank cell. If two users enter the data at the same time i
produces a conflict error on exit.

Is there a way of reflecting the changes made by other users before m
code runs to find the next cell and thus enter it in a truly vacan
cell?

Thanks

--
Message posted from http://www.ExcelForum.com

Update a shared workbook.
 

Hi,

My suggestion is to have a "At The End of day" Button.
You will need to create a Master WorkBook so that at the end of the da
Is selected it will open modify and close the Master. This should help


HTH

Charle

--
Message posted from http://www.ExcelForum.com

Update a shared workbook.
 

Thanks for your reply Charles.

What I neglected to mention is that the code looks for unique value
when it runs therefore the 'master' must be updated each and every tim
the user enters code.....

--
Message posted from http://www.ExcelForum.com

Update a shared workbook.
 

Hi,

I'm not sure if it can be done then. To the best of my knowledge i
someone is active the another person can not update because they wil
have to open as a read only. Mybe someone else my know of away.


Charle

--
Message posted from http://www.ExcelForum.com

Update a shared workbook.
 

Hmmmm.....

Does anyone know if I am on the right lines wit
AutoUpdateSaveChanges?

From good old help....

"This example causes changes to the shared workbook to be posted t
other users whenever the workbook is automatically updated.

ActiveWorkbook.AutoUpdateSaveChanges "

Any idea if this will update remote users when a manual save happens?

Gonna give it a try......

--
Message posted from http://www.ExcelForum.com

Update a shared workbook.
 

Just in case anyone else is searching this thread the solution appears
to be;

Activeworkbook.autoupdatefrequency=0
Activeworkbook.autoupdatesavechanges=true

Frequency to zero means that updates only occur when a manual save is
done.
autoupdatesavechanges promulgates changes to all users.

:)


---
Message posted from http://www.ExcelForum.com/

Update a shared workbook.
 

Thanks I learned something new.

Charle

--
Message posted from http://www.ExcelForum.com