Hi,
Could u please give a solution for the following query.

I receive around 10 XLS files everyday. I want a macro which will do the
following:

In every file opened a marco must look for the name of a City in the Cell
D9 and then save the workbook in the already existing subfolder which has the
same name as the city.

For Example

There are the following subfolders existing:
Washington, Caliornia, New Jersey, Pilphedia,

if D9 has "California" the macro must save the file in folder "California".

Eagerly waiting for a reply and Thankyou in Advance.

Regards,

MADHU