Copy files from listbox and paste in user defind location

**klonbeck** · 12-11-2012, 04:21 PM

I have had some help with other parts of this but I am stuck again. I am trying to copy files/folders from a user defind location and then paste them in another user defind location.
I can get my listbox 1 & 2 to populate like I wanted, but when I submit the selection I get "Run-timer error '76': Path not found" (see FILE PATH NOT FOUND.PNG)

When I check the line that is failing with; ?FSource & "\" & Me.ListBox2_Destination_Files.List(1), I get the true location of the file to be copied so I dont know what is wrong.

I have attached my spreadsheet for reference.

thank for the help.

**klonbeck** · 12-14-2012, 12:35 PM

I just noticed that my destination path was missing a "\" at the end of the string. Example: if your path looks like this "C:\Users\Public\Documents" then Excel thinks Documents is a file, but if you add "\" to the end of the string "C:\Users\Public\Documents\" Excel now knows that Documents is a folder.

I was also using copyfolder when what I really wanted was copyfile.

Copy files from listbox and paste in user defind location

LinkBack

Thread Tools

Rate This Thread

Display

Copy files from listbox and paste in user defind location

Re: Copy files from listbox and paste in user defind location

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions