move files to folder based on a .igy list

Hello,

I have a problem with file moving.
I have a .iqy (web based excel list) which is contanty updated. On the other hand I have a folder with files(pdfs and autocad) that have a specific name that matches(or doesn't) with one from the igy file.

Now I really want to automated this and it is driving me crazy. Can anyone help me with this?
What I am looking for is that I open the .iqy file. Then select the macro and let it run in the folder that I need to check. And then the files that are
not in the list should be moved to a folder and the ones that are in the list to another folder.

Hope someone can help me. (I have limited VBA skill but am willing to try anything!)

best regards,

little bump!

Made it even easier, I have a .txt list of the all the files and in a folder I have files that are either in the list or not.
I would like then to be seperated into 2 folders according to the .txt list file..

Thank you for your reply.
I am having trouble using your code. With what can I use the code?
Should I open excel? or create a bat file of it?
Because I don't know how to use your code...
I am a real beginner...

thanks on forehand!

Hi,

I am sorry for the low level of skills, I managed to create a VBA routine and it gave an error 450 in :
dctFileList.Add strFileName

I think I managed to let it run...
But maybe I need some more lessons in how to use VBA.

cheers

I keep getting the same error:
error 450 in :
dctFileList.Add strFileName

what does this mean?
I managed to move alle the files already with excel/VBA but now it must be by the list!

thanks