How do I check modifications of file on server

A

Alan

I have one workbook BOOK.XLS on my server
My macro copied this file to my local comp. and put some changes on it.
I have to return this file to server.

How to check if someone else change something on this file. (maybe to check
time of last saving)

Thanks

Alan
 
D

Dave Peterson

I'd do this if I had to update that file.

copy that network file to your local pc.
Open a new workbook and put
This File is being updated by Alan XXXXX.

Then save this new file with the same name as the original. If a user opens it,
they won't be able to update anything meaningful.

Then when you're done with your updates, you can copy your version to its
rightful location.

If you allow two people to update the file locally, sooner or later you're going
to destroy someone's work.

Is there a reason you can't update it in place?

====

If you go into windows explorer and traverse to that folder and show the file
details, you should be able to see the last date changed.

But if it's changed, what do you do next? Grab another copy and make your
changes again???
 
A

Alan

Dave,
this workbook is "wearehouse.xls" with column qty. and reserv.qty
when someone wnat to make "offer.xls" then local program copy warehouse.xls
from server to local pc
when "offer.xls" is made and items should be reserved - program update this
res.qty in "warehouse.xls" and sve it localy.
Then program is coping this "warehouse.xls" to server. Problems is if
someone did same thing same time.


Thanks Dave

Alan
 
D

Dave Peterson

This is a big problem with multiple updates to copies of a master file.

I try to avoid it from happening by only allowing one person to update the
file--and if that person has to update a copy of the file, then I find it's best
to somehow lock/disable/prevent others from updating the master workbook.

There is another option, though. Let everyone update the master in its current
location on the network drive. You can do this with a shared workbook.
Tools|share workbook under the menubar is where you'd find how to set this.

The bad news is that there are lots of things that can't be done in shared
workbooks--but you may find it sufficient for your purposes. (I don't recall
ever using one of these in real life--because of those restrictions.)

But there is nothing built into excel that will compare workbooks to find the
differences.

I try to stay away from multiple people updating copies of the same workbook
(but I've said that already).

Another option if you really want multiple concurrent users to update a database
would be to use a real database (Access, maybe). (But I've never used that,
either.)

Good luck,
 
A

Alan

Thanks Dave
Mr. Doug, Microsoft Access MVP send me good solution
With comparing date/time and size of file

I know that Access is great thing for databases but unfortunately I start
with small vba code
after 3 years of upgrading, program is more then 5500 lines long so now i
have to deal with
hundreds of problems (but still i have great experience with Excel VBA)

Thanks for your time Dave

Best regards

Alan
 
Top