Avatar of Nick Collins
Nick Collins
 asked on

Copy and move files

All experts,

Trying to think of the best solution to copy files and then move to another folder.

Step by Step Instructions

1. Source folder contains multiple pdf files
2. Create a folder with today’s date in another directory
3. Copy all the PDF files into this new folder
4. Move PDF files into another directory ready for processing
5. The Source is empty

That’s the logic.. What’s the best way to do this
VB ScriptVBA

Avatar of undefined
Last Comment
Bill Prew

8/22/2022 - Mon
Bill Prew

So, do you need a VBA or VBS solution???


»bp
ASKER CERTIFIED SOLUTION
Bill Prew

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Nick Collins

ASKER
Thank you - I am getting an error message 'Cannot use parentheses when calling a  sub'
Bill Prew

What line?

And how are you running this?


»bp
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
Nick Collins

ASKER
It's the last line..  moving the files
SOLUTION
Bill Prew

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.