This is the script as I have it now, and it will successfully move a folder from the previous day to the current monthly folder (ie. on August 19th (2009-08-19) it will take the folder named 2009-08-18 and move it to the monthly folder 2009-08). I plan to schedule this to run Tuesday through...
Success! Works like a charm!
Thanks very much for all your help!
I had to make one other small change - I forgot that when I get around to moving the folder it is likely to be past midnight, so I had to add a '-1' to the day portion of the date, so it goes back one day.
Do you think this...
That was one thing I was thinking, but I created the folder structure locally for testing, and the folder where the monthly folders are located is empty prior to running the script. When I run the script, it creates the proper monthly folder (2009-08), but then won't copy the daily folder into...
Closer still... I can now create the desired monthly folder, but I get a 'File already exists' error. I did some more testing and modified the script a little, and I think it is almost there...
------------------------------------------------------------
Dim fldDaily
Dim fldMonth
fldDaily =...
I think I am getting closer - the script will create the new folder in the correct place, but it is not using leading zeroes in the date, so I think that is why it is throwing the 'Path not found' errors?
Example: When the script creates the new folder, it is in the format 2009-8, instead of...
Thanks for the help. This is throwing an error on the last line 'Path not found'. I was getting the same thing with my attempts as well. I tried removing the '& Year...' from each line as a test, but still got the same error.
I did notice a typo in the objFSO.MoveFolder command that I fixed...
I need to come up with a script to do the following:
I have a folder on a server in which people scan documents to PDF. The folders are simply named for the day (for example 2009-08-12 for August 12, 2009). At the end of the day, I would like to move the daily folder into a monthly folder...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.