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

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.
JaysonJacksonAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Bill PrewCommented:
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
JaysonJacksonAuthor Commented:
yes c:\scan
0
Bill PrewCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
JaysonJacksonAuthor Commented:
Thanks so much Bill!!   this worked
0
Bill PrewCommented:
Great, glad that was useful.

~bp
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
VB Script

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.