Move files to folders

Hi Everyone,

I have 8 folders on my desktop namely A, B, C, D, E, F, G & H. Path of these folders are

A: C:\Users\hp\Desktop\Test 1\A
B: C:\Users\hp\Desktop\Test 1\B
C: C:\Users\hp\Desktop\Test 1\C
D: C:\Users\hp\Desktop\Test 1\D
and so on till folder H

In another folder at different location i have 4 excel files namely W, X, Y & Z
file path of these 4 files is : C:\Users\hp\Desktop\Test 2

I am looking for a vba code that will copy file W to folder A and B both
file X to folder C and D both,
file Y to folder E and F both,
file Z to folder G and H both.

Kindly assist me in this.

Thanks a lot in advance.

Obviously not tested...

Please Login or Register  to view this content.

Hi dangelor,

Thnaks for the reply.

I am geeting error as this step:
FileCopy B & U(j), A & V(i)

stating File not found. But i have Files in Folder Test 2

Thanks,
Saurabh

I am geeting error as this step:
FileCopy B & U(j), A & V(i)

stating File not found. But i have Files in Folder Test 2

I assumed W, X, Y and Z were placeholders for the real file names. Try replacing the letters in this line

Please Login or Register  to view this content.

with the actual file names.

Hi Sintek,

This worked perfectly. Thank you so much for this.

Just one change i want to do and that is, not necessary 1 excel workbook will go to 2 folders.

Currently situation is
File W should go to folder A & B
File X should go to folder C D E and F
Y should go to G H and I
and File Z should go to folder J and K

is it possible?

Thanks in advance.