| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro that searches 5 files .xls and in every worksheet in every file is looking for "text".
Hi,
I am rather novice user of Excel VBA. My "macro" problem is: 1. Open 5 .xls files. 2. In every worksheet of every file check if Range("A1").Value is "Text" 3. Close 5 .xls files. 4. Print the results of searching f.e. "I have found "Text" 56 times." in new workbook. Please help... I'm looking forward to hearing from you :) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| text string: "91E10" in csv file auto converts to: "9.10E+11" | Excel Discussion (Misc queries) | |||
| VLOOKUP gives duplicate results for "empty" searches | Excel Worksheet Functions | |||
| .csv drops "0" when saved, even if file was set as "text". | Excel Discussion (Misc queries) | |||
| Sending macro based e-mail with built-in "Heading" and "Text" | Excel Programming | |||
| How to use macro to rename worksheet with date +"text" | Excel Programming | |||
Threaded Mode
