Copy a pdf fil from 1 folder to another

[SQUIDD]

Hello All

I am trying to copy .pdf files from 1 folder to another. This i can do.

But, i want to only copy the ones that have -SW at the end of the pdf name.

from N:\OFFICE\PROJECT QUICK QUOTES\22687

to N:\PRODUCTS\PRODUCT FOLDERS\22687

example of pdf name : BBLight-SW

Any help would be appriciated

thanks

Dave

 

[John_w]

It depends how you're looping through the files in the source folder.

For a native VBA Dir loop you would specify the initial Dir file search like this:

PDFfile = Dir(sourceFolder & "*-SW.pdf")

For a FileSystemObject loop you would look for matching files with the Like operator like this:

If LCase(FSOfile.Name) Like "*-sw.pdf" Then

 

[SQUIDD]

Thanks John

Thats very helpful.

I am considering my options on this, as i may just drop the relevent .pdfs into a folder and copy the whole folder.