Thread: Macro that searches 5 files .xls and in every worksheet in every file is looking for "text".
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
vt7 vt7 is offline
external usenet poster
  
Posts: 2
Default 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 :)

Reply With QuoteReply With Quote