prefix folder name to files with excel vba

Hi

I have many folders each folder has separate name inside that folders there are some pdf files and each file should get prefix name of the particular folder.

Example : FolderName --->Test -------> Test folder -----> i have pdf files ------------>files names will be text1.pdf, text2.pdf ,text3.pdf

output :Testtext1.pdf ,Testtext2.pdf,Testtext3.pdf


In Single Example folder i have 150 folders all folders have uniques names and files.

all i want is each folder name should apply to files inside that folders (Required loop through each folder prefix folder name to files and exit and goto do the same)


Thanks in advance

Hello
Can you spot on the problem by giving more details ..? You can use snapshots to show the final desired output

Something like this...Put the macro file in the Example folder

Please Login or Register  to view this content.

Your hierarchy...As I understand it...
Main Folder...store excel file containg code in this folder...
Sub Folder
Folder
PDF file...Which must be renamed to SubFolder & pdf File.name

Try this code

Please Login or Register  to view this content.

You're welcome. Glad I can offer some help

I didn't get what you mean ..?
Do you mean you need to move those files to another location ...?

I didn't get your words

i want to find which is searchable pdf and which is not searchable pdf

Can you explain the difference between those two kinds of PDFs?

I have no idea how to differentiate between those two kinds of PDFs
I recommend that you post new thread with this new request ...

Try this version

Please Login or Register  to view this content.