Copy selected files into a specific directory

[Wizz]

Hi,
I need a procedure to:
a) let the user select any file (name or type)
b) Paste the selected file in a Specific folder.

Part a) is easy. I used the

Please Login or Register  to view this content.

line.
How can i accomplish part b)?? I dont need to open the files. Just to save them in the folder I choose. Those files could be any type. From .pdf to .fgs to anythig.

Thanks

[mudraker]

Heres 1 method - It moves the file

Place all the code in a normal module
Run MoveFile

Please Login or Register  to view this content.

[Wizz]

Hi Mudraker,
I Must NOT modify the original. Is there a form to have a duplicated file in the new folder?

[ravishankar]

Hi
If you don't have too many files, Let
A1= source file path (G:\macro\upload\)
A2= source file name(with extention)(wizz.xls)
A3= Destination file path(F:\coffee\sugar\)
A4 = destination file name(with extention)(Wizard.xls)

Please Login or Register  to view this content.

Ravi

[Wizz]

Excelente !
Just what I needed.

Thanks you very much Ravishankar and Mudraker.