Update a shared workbook.

[Unknown_User]

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

 

[Charles]

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

 

[Unknown_User]

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.....

 

[Charles]

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

 

[Unknown_User]

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......

 

[Unknown_User]

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.

 

[Charles]

Thanks I learned something new.

Charle