Copying files from a selected filepath to a filepath mentioned in a worksheet's cell

[subbby]

What I am trying to do is :

• Have the VBA pgm ask the user the folder where the files are located
• and have them copied to a file path mentioned in a cell

Tried the following code:

Please Login or Register  to view this content.

Courtesy : Above code is a modified one found on http://www.rondebruin.nl/folder.htm





Any help is much appreciated. thanks

cross posted
http://www.ozgrid.com/forum/showthre...446#post627446

[subbby]

SOLVED IT :

modified the code and had replaced a few lines with

Please Login or Register  to view this content.

Courtesy : http://en.allexperts.com/q/Excel-105...-Using-VBA.htm