Write locking a file in visual basic

XML, Perl, Python, and other languages can be discussed here, even if it isn't PHP (We might forgive you).

Moderator: General Moderators

Post Reply
AshrakTheWhite
Forum Commoner
Posts: 69
Joined: Thu Feb 02, 2006 6:47 am

Write locking a file in visual basic

Post by AshrakTheWhite »

or view locking a file, not sure, anyway the problem is:

we have a bunch of excell files which get opened by a batch file, once opened a macro runs that gets data from somewhere, and once the data is updated in the excell file the batch file closes, unless someone else is looking at the file at that time, so we pretty much need a way to lock the file from viewing BEFORE we start updating, so the excell doc dosent prompt for an overwrite (which is the problem, cause it runs at 1am and is needed the next morning) the save procedure also occurs in the macro, so pretty much what we need is a way to say "yes" on all prompts without any user action.



any clues on how to?
Post Reply