calvarado536
Technical User
I already have a script that creates a new folder in a directory every day with the date from the day before. (have the script running with task scheduler daily). Spreadsheets are saved to this directory as well and they need to be put into the correct dates folder. I need help writing a VBScript that will take all the .xlsx files in the directory and put them into the folder with yesterdays date. This is the script that I have so far, I need help with having the script figure out the date for the go to folder.
Option Explicit
Dim fso
Set fso = CreateObject("Scripting.FileSystemObject")
fso.MoveFile "C:\Payment Report\*.xlsx", "C:\PART THAT I NEED HELP WITH"
Option Explicit
Dim fso
Set fso = CreateObject("Scripting.FileSystemObject")
fso.MoveFile "C:\Payment Report\*.xlsx", "C:\PART THAT I NEED HELP WITH"