Open files which contains given keyword

[Valli]

Hi Everyone,

Thanks in advance for helping me. Sorry for the English.

I would like to open files from a given folder which contains some
keywords in the file name.

Let us take an example:

A folder contains around 100 excel files, i would to open file which
contains the keyword "abc sales" in the file name. If any of the files
having this word in the file name, then that file should be opened.

Can anyone help me.

Cheers

Valli

 

[Ron de Bruin]

Hi Valli

I have this option in my merge add-in
http://www.rondebruin.nl/merge.htm

With code you can test it like this
I use the first code example from this page
http://www.rondebruin.nl/copy3.htm

You can change this line

FilesInPath = Dir(MyPath & "*.xl*")

File names that start with week
FilesInPath = Dir(MyPath & "week*.xl*")

Or contain week
FilesInPath = Dir(MyPath & "*week*.xl*")

 

[Valli]

It works great. Thanks Ron de Bruin.