save files in specific folder after being uploaded to intranet

Hi all,

As part of a macro that I'm currently making, there is a step that needs to be taken too.
I have now almost completed a macro that will upload files into an intranet site.
First I run a macro to get all the files from a folder into the excel sheet in column G. the file name and file path is in there. When the macro start uploading the files, it loops one by one. when the loop loads one up, it should use the full path of the file to select the file and cut it from the folder it is in and move it to a folder called dump in the root of C drive.

Thank you in advance and greetings.

Ron De Bruin has some useful code examples here for file functions:

http://www.rondebruin.nl/win/s3/win026.htm

Hi,

I checked the site and found one to use (well, almost). The thing is that it moves the whole folder. What I need is that it loops trough a column and find the listed file name and use that file name to move the file to a different folder.
The file name I have in column A. I will have other files in that folder too, but only the ones that I have listed in the excel sheet column A should be moved.

What code part to I need to change to make it work?

Please Login or Register  to view this content.

Greetings.