PDA

View Full Version : search for words or symbols in files



stefanoste78
07-30-2018, 03:28 AM
Good morning. I need your help.
Is it possible to search for words or symbols in files?
The macro, when it is launched must be able to give me the possibility to indicate which folder contains the files or the individual files to analyze and the sheet in which to insert the results. In the moment that I indicate the path to follow to macro must indicate in the report sheet the list of the names of the files contained or selected by creating a hyperlink and for each file must indicate the number of words or symbols contained within the whole file ( referred to all the sheets of which the file is composed). I will insert the symbols and / or words will be indicated in the whole line (so will not be only those you see currently). Moreover, when I insert other files in the folder and launch the macro again, the described procedure will only affect the new files without deleting the results already extracted.
I am attaching the files to give you an idea.
Thanks in advance

https://www.dropbox.com/s/8xnu1cj24h...e%20x.rar?dl=0 (https://www.dropbox.com/s/8xnu1cj24h7cjy0/file%20x.rar?dl=0)


forum list where I entered the same post:
www.excelguru.ca

macropod
07-31-2018, 03:52 AM
When cross-posting, please provide the full path: https://www.excelguru.ca/forums/showthread.php?9225-search-for-words-or-symbols-in-files

stefanoste78
07-31-2018, 05:47 AM
When cross-posting, please provide the full path: https://www.excelguru.ca/forums/showthread.php?9225-search-for-words-or-symbols-in-files



You should see well before ..