FileCopy list of files to another folder

[Tortus]

I'm trying to create a way for users to copy files based on check boxes.

Column A is linked with the checkboxes. If "TRUE" is found in column A - offset 6 on the right lists the path and file name. I would like to copy that file and move to C:\apps\print\

Please Login or Register  to view this content.

Also tired FileCopy sourcepath, dstpath

[Alf]

C:\apps\print\

Am I missing something? When you create a folder should not the string be "C:\apps\print"

Your dstPath is of cource right.

An alternative command to making a directory could be

Please Login or Register  to view this content.

Alf

[Tortus]

Creating the folder is working as I expected. I think the problem is the source path or how excel translates the link in the cell. The sourcepath is showing blank but I know I'm on the correct cell with the file listed that I am trying to copy to c:\apps\print\

[Tortus]

Please Login or Register  to view this content.

Got it!