Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open files which contains given keyword
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open files which contains given keyword
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*") -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Valli" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open files which contains given keyword
It works great. Thanks Ron de Bruin.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I toggle between 2 open excel files and leave both open | Excel Discussion (Misc queries) | |||
How to change default Open/Files of Type to "Microsoft Excel Files | Excel Discussion (Misc queries) | |||
HOW TO GET OVER WITH THIS ANNOYING LINKED FILES MSG BOX WHEN I OPEN FILES WHICH HAS LINKS | Excel Programming | |||
Macro to open *.dat files and save as .txt (comma delimited text files) | Excel Programming | |||
file open via IE hyperlink causes already open files to shrink and tile | Setting up and Configuration of Excel |