Avatar of Dale James
Dale James
 asked on

Move file to another folder based on partial filename

Hello Team

Can you please advise on the following?

Using VBA code, I wish to move an excel file from one folder to another if the file name contains "Mail Count Report" in the filename.

Source Folder:  C:\Reports\
Destination Folder:  C:\ Reports\Archive\

Thank you in advance.

Dale




Windows 10VBAMicrosoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Alex [***Alex140181***]

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Alex [***Alex140181***]

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.
SOLUTION
Subodh Tiwari (Neeraj)

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.
Dale James

ASKER
Thank you Alex and Subodh, exactly what I was looking for.

Both solutions work perfectly.

Many thanks.

Sincerely

Dale
Subodh Tiwari (Neeraj)

You're welcome Dale! Glad we could help.
Alex [***Alex140181***]

You're welcome ;-)
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck