Solved

Need a VB script that will create a folder and move files.

Posted on 2014-11-22
5
85 Views
Last Modified: 2014-11-24
I am looking for some assistance with a VBS script.

The script will be scheduled to run nightly and do the following

Create a subfolder with yesterdays date (example today is 11_23_2014 the folder created would be 11_22_2014)

The move all files from c:\scan\ to the Newly created folder


This does not sound hard but it is kicking my rear.
0
Comment
Question by:JaysonJackson
  • 3
  • 2
5 Comments
 
LVL 52

Expert Comment

by:Bill Prew
ID: 40459789
Under what folder would you like the dated daily folders created?

I assume there are only files and not subfolders to move from C:\SCAN?

~bp
0
 

Author Comment

by:JaysonJackson
ID: 40459800
yes c:\scan
0
 
LVL 52

Accepted Solution

by:
Bill Prew earned 500 total points
ID: 40459826
Give this a try and see if it is acceptable, it should do what you described.

' Specify folder to work in
strBaseDir = "C:\Scan"

' Create filesystem object
Set objFSO = CreateObject("Scripting.FileSystemObject")

' Quit if specified folder doesn't exist
If Not objFSO.FolderExists(strBaseDir & "\") Then 
   Wscript.Echo "Base folder missing, ending."
   Wscript.Quit
End If

' Calculate yesterdays date, format as MM_DD_YYYY
dtmValue = DateAdd("d", -1, Now())
strDate = LPad(Month(dtmValue), 2, "0") & "_" & LPad(Day(dtmValue), 2, "0") & "_" & Year(dtmValue)

' Create destination folder with yesterdays date
strDestDir = strBaseDir & "\" & strDate
objFSO.CreateFolder strDestDir

' Move all files in base directory to dated folder
objFSO.MoveFile strBaseDir & "\*.*", strDestDir

' Done
Set objFSO = Nothing

' Left pad a string to any length with a specified character
Function LPad( strText, intLen, chrPad )
   LPad = Right( String( intLen, chrPad ) & strText, intLen )
End Function

Open in new window

~bp
0
 

Author Closing Comment

by:JaysonJackson
ID: 40462534
Thanks so much Bill!!   this worked
0
 
LVL 52

Expert Comment

by:Bill Prew
ID: 40462758
Great, glad that was useful.

~bp
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Unlike scripting languages such as C# where a semi-colon is used to indicate the end of a command, Microsoft's VBScript language relies on line breaks to determine when a command begins and ends. As you can imagine, this quickly results in messy cod…
Not long ago I saw a question in the VB Script forum that I thought would not take much time. You can read that question (Question ID  (http://www.experts-exchange.com/Programming/Languages/Visual_Basic/VB_Script/Q_28455246.html)28455246) Here (http…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now