PDA

View Full Version : VBA Code help - Search files within folders and return file name and path



jesmac
04-04-2018, 12:49 AM
Hi there,

I am very new to VBA and I have a problem that I know VBA can help me with but I can't figure out the coding.

I have a folder with subfolders and hundreds of files within them.
I have a list of ~500 terms that I need to remove from these files so I need a code that will search the files for my specified terms and tell me what files they are in (the file name and path).
I have excel and word documents that I need to search through.

I have found codes that are supposed to help me and I have tried few, but I can never get them to work 100%.

Someone help me please!!!!

SamT
04-08-2018, 03:17 PM
Moderator Bump