Re: Script to close open files in a folder?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

here you go

http://dev.thatsit.net.au/Samples/WSH/thatsIT/miso/remote.asp



"Raul" <raul@xxxxxxxxxxx> wrote in message
news:07DE0665-A662-4E40-837E-E16EC94A363C@xxxxxxxxxxxxxxxx
I don't know how to run the script on all the machines on the network, or
any
remote machine on the network, so I'll take you up on your offer.

I'm holding on to the hope that I can use a WQL query to be more selective
about which machines the script will actually have to run on, but we'll
take
this one step at a time.

Thanks again for your help,
Raul

"Slim" wrote:

You need to run this script locally on all machines.
http://dev.thatsit.net.au/Samples/WSH/thatsIT/office/closeWordDocs.asp

If you not sure how to do that give us a yell?


"Raul" <raul@xxxxxxxxxxx> wrote in message
news:25E8D399-2913-459A-BB95-5F01D894ED00@xxxxxxxxxxxxxxxx
The files that people are looking at are "read only" so there isn't
much
risk
of anyone losing any work. I have read and write access to that folder
and
everyone else has read access.

I am essentially using solution you just suggested; the second folder
just
happens to be on my PC (not on the server) and I'm manually overwriting
the
files on the server because my VBA crashes if someone has a file open
on
the
server.

The issue is having to determine who has a file open and then closing
the
file if someone does have a file open. This entails getting in touch
with
the network administrator who in turn uses MMC to determine which IP
address
is using the file and closing the file. I don't know the specifics,
but
the
whole process can take several hours when you factor in getting in
touch
with
someone and then that person getting around to doing it.

I'd like to be able to use "Scheduled Tasks" on the server to run a
script
once a day (at 07:00 when most people are not on the network) to close
any
open files in a particular folder. After any open files are "closed" I
can
then use VBA or "Scheduled Tasks" with an appropriate script on my PC
to
overwrite the existing files on the server.

If I can't close an open file, is there a way to use script to
determine
which IP address is using the file?

Thanks,
Raul

"Slim" wrote:


"Raul" <raul@xxxxxxxxxxx> wrote in message
news:A999E0FB-6931-445A-B7D7-1BCDB510216B@xxxxxxxxxxxxxxxx
We have a folder on a server that contains a number of excel files
and
word
files that users can access from their computers. The files on the
server
are updated fairly regularly by pasteing new files to replace the
old
ones.
We run into trouble when a user has one of the old files open when
we're
trying to paste the replacement file into the folder.

Is there a way to close any open files in a folder using vbscript?

Thanks,
Raul

I don't think doing so would be easy, you would have to run a script
on
every computer and you may cause someone to lose some work.

Why don't you drop them into a second folder, then activate a script
from
scheduled tasks at a interval to check that the same version file is
in
both
folders. If the version is older the script should copy the new file
across,
if it can not because a user has it open, then it will do so again
next
time
the script runs








.

Relevant Pages

  • Re: filename is too long or contains illegal caracters
    ... server because I can publish the same web site over the same connection using ... past told me they don't know anything about Publisher). ... When I ADD NETWORK LOCATION, I get "folder ... Per you suggestion, I tried to Add a Network Location in "Computer", ...
    (microsoft.public.publisher.webdesign)
  • Re: SBS Add User wizard problem
    ... It turned out that the reason was script's folder ... The rest of settings are ok (it means they are like You said they ... Say I have a script on server which checks every 15 ...
    (microsoft.public.windows.server.sbs)
  • Re: "you might not have permission to use this network resource"
    ... Contact the administrator of this server to find out if you> have ... Networking, Internet, Routing, VPN Troubleshooting on ... How to Setup Windows, Network, VPN & Remote Access on ... When I attempt to access a private folder or a public folder ...
    (microsoft.public.windows.vista.networking_sharing)
  • Re: HELP ME PLEASE! Very bad performance of file sharing
    ... I ran the Microsoft Network Monitor on both machines and ... folder contents from Server. ... File Monitor showed no activity (perhaps folder contents are read ... On the client File Monitor showed explorer.exe reading the folder. ...
    (microsoft.public.windowsxp.network_web)
  • Re: DHCP Reservation issues
    ... but what about your login script details/reasons for doing this/etc? ... You may be able to set up your network more efficiently if you provide ... new problem I have is that the SBS server where the DHCP ... even though I set a reservation for them in the DHCP console ...
    (microsoft.public.windows.server.sbs)