UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Moving Files With Vbscript, Windows 7, VBS    
 
   
EdNerd
post Nov 25 2014, 12:30 PM
Post#1



Posts: 764
Joined: 23-May 11



I am not a SysAdmin - I'm running everything client-side.

I need to move files from a public folder to a more restricted folder. I have permissions to both. I can create a VBScript that will move the files with no problem.

My issue is scheduling this. I'd like this to run often - very often. If there was a way to constantly monitor the public folder and as soon as the file count increased to jump on it and move it, I'd do it that way. But I have no idea how much overhead a script running constanly in the background like that would eat up on my computer.

Otherwise I *think* I have permissions to set the Task Scheduler to run a script periodically. But again, if this script pops up every 20 minutes or so and moves files across servers (nothing gets transferred onto or off my computer), how much of my computing overhead is this going to take? Is it likely to paralyze my machine until all operations are completed?

Ed
Go to the top of the page
 
DanielPineault
post Nov 25 2014, 01:24 PM
Post#2


UtterAccess VIP
Posts: 5,437
Joined: 30-June 11



How about something like: http://blogs.technet.com/b/heyscriptingguy...o-a-folder.aspx
Go to the top of the page
 
JonSmith
post Nov 25 2014, 03:37 PM
Post#3



Posts: 3,158
Joined: 19-October 10



Checking the status of the folder - zero overhead.
Moving the files - depends on the files but likely not too much.

At the end of the day you are asking how long is a piece of rope. Your specs, network speed and file size all come into play. How long does the current script take? How much resources does it currently drain? You have your answer.
Go to the top of the page
 
EdNerd
post Nov 25 2014, 06:42 PM
Post#4



Posts: 764
Joined: 23-May 11



Daniel: That link looks like just what I need! Thank you.

Jon: At the moment, this runs as a VBA macro in a Word doc in the OnOpen event. At first run, it moved 260-ish files in about 20-30 seconds. Al the files are Excel workbooks - anywhere from 350K to 10,000K.

Thanks for the help!! I appreciate the boost.
uarulez2.gif

Ed
Go to the top of the page
 
DanielPineault
post Nov 25 2014, 07:28 PM
Post#5


UtterAccess VIP
Posts: 5,437
Joined: 30-June 11



thumbup.gif
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    11th December 2017 - 06:25 AM