I'm attempting to write a vbscript that will copy a directory to a specified location. The current direcoty is located at C:\l and I want to copy the direcotry to C:\Location2. Here's the tricky part that I can't seem to figure out. The direcotry changes every day based on date. For example today's directory would be 20080929. The script I've tried is below which doe snot seam to work.
Set objFSO = Createobject ("Scripting.FileSystemObject")
strMonth = Right("0" & Month(Date), 2)
strDay = Right("0" & Day(Date), 2)
strYear = Year(Date)
Myfile = strYear & strMonth & strDay
objFSO.CopyFolder "C:\MyFile", "C:\Test\"
WScript.Echo "File Copied"