Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search text in multiple files in multiple directories
Problem: Multiple Excel files in multiple directories that all need to be
queried for differnt string values. Unknown - I am not sure if I will be expected to simply find the text strings, count them or return all of them individually or along with other data in the same record or row of the spreadsheets. If anyone know of code, add-ins, or resources (both people or knowledge base type articles) any help would be appreciated. If more information is needed before you can even suggest anything please let me know. Thanks, Andrew |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search text in multiple files in multiple directories
go through systemFileObject help
u can find ur answer -- hemu "Andrew" wrote: Problem: Multiple Excel files in multiple directories that all need to be queried for differnt string values. Unknown - I am not sure if I will be expected to simply find the text strings, count them or return all of them individually or along with other data in the same record or row of the spreadsheets. If anyone know of code, add-ins, or resources (both people or knowledge base type articles) any help would be appreciated. If more information is needed before you can even suggest anything please let me know. Thanks, Andrew |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search text in multiple files in multiple directories
Andrew,
How is the data organised ? Is it all in structured tables like a database, or all over the place ? If it's structured, you can use ADO/SQL on the closed workbooks. Otherwise, you'll need to open each and use .Find . NickHK "Andrew" wrote in message ... Problem: Multiple Excel files in multiple directories that all need to be queried for differnt string values. Unknown - I am not sure if I will be expected to simply find the text strings, count them or return all of them individually or along with other data in the same record or row of the spreadsheets. If anyone know of code, add-ins, or resources (both people or knowledge base type articles) any help would be appreciated. If more information is needed before you can even suggest anything please let me know. Thanks, Andrew |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search text in multiple files in multiple directories
It looks like it's a mix. Several spreadsheets have column/field headers
structured just like a database but other spreadsheets have data all over the place. Thanks for the ADO/SQL tip. "NickHK" wrote: Andrew, How is the data organised ? Is it all in structured tables like a database, or all over the place ? If it's structured, you can use ADO/SQL on the closed workbooks. Otherwise, you'll need to open each and use .Find . NickHK "Andrew" wrote in message ... Problem: Multiple Excel files in multiple directories that all need to be queried for differnt string values. Unknown - I am not sure if I will be expected to simply find the text strings, count them or return all of them individually or along with other data in the same record or row of the spreadsheets. If anyone know of code, add-ins, or resources (both people or knowledge base type articles) any help would be appreciated. If more information is needed before you can even suggest anything please let me know. Thanks, Andrew |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search text in multiple files in multiple directories
Andrew,
If you know which is which, use ADO on the DB/table structures and ..Open/.Find on the others. Not sure if there is something in the older Macro4/GET stuff that can help. NickHK "Andrew" wrote in message ... It looks like it's a mix. Several spreadsheets have column/field headers structured just like a database but other spreadsheets have data all over the place. Thanks for the ADO/SQL tip. "NickHK" wrote: Andrew, How is the data organised ? Is it all in structured tables like a database, or all over the place ? If it's structured, you can use ADO/SQL on the closed workbooks. Otherwise, you'll need to open each and use .Find . NickHK "Andrew" wrote in message ... Problem: Multiple Excel files in multiple directories that all need to be queried for differnt string values. Unknown - I am not sure if I will be expected to simply find the text strings, count them or return all of them individually or along with other data in the same record or row of the spreadsheets. If anyone know of code, add-ins, or resources (both people or knowledge base type articles) any help would be appreciated. If more information is needed before you can even suggest anything please let me know. Thanks, Andrew |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search for text in multiple columns | Excel Discussion (Misc queries) | |||
Multiple text search in a cell | Excel Discussion (Misc queries) | |||
Automated multiple text files into multiple sheets in one workbook | Excel Discussion (Misc queries) | |||
Search for text in multiple excel files | Excel Programming | |||
view multiple files in multiple windows on multiple screens. | Excel Discussion (Misc queries) |