Coping PDF Files with Excel

[CobraLAD]

I manage to create a nice file copier, but I have 2 problems, Please Help

I'm using a userform.

I have a button to select the main folder where all the pdf files must go to, and then the location is saved in the registry, so everytime I run the userform the main folder is selected. I am using this code, and it works 100%

Please Login or Register  to view this content.

then I select the folder where the pdf files is with a second button, and only PDF files is selected. I am using this code, and it works 100%

Please Login or Register  to view this content.

the Listbox is set to MultiSelect = fmMultiSelectMulti and ListStyle = fmListStyleOption

Then I copy the selected item to the main folder
I am using this code, and it works 100%

Please Login or Register  to view this content.

Q1. I want to use the file browser not the filedialog picker. I manage to select the folder, but it lists all the file. How do I get it to select only pdf files, and I also want to list the files in a Listbox on Userform

the code for the browser.

Please Login or Register  to view this content.

Q2. How do I set the button that copies the files to check if the files is already in the main folder.

[Leith Ross]

Hello CobraLAD,

It would be easier to make the necessary changes, if the workbook were available. Posting the workbook will also reduce the question and answers needed to develop a solution quickly.

[CobraLAD]

I solved Q1 of selecting only pdf files, using browser and listing them in a Listbox

I need help with:

The workook must check if file(s) listed in listbox is already in the main folder before coping.

Workbook attached.