Email from Work Sheets&Workbooks

[Blessy Clara]

Hi All,

I have 300+Excel workbooks -
Each work book has 5 to 10 Sheets of Data and Emails occur in different columns within the sheets

Is it possible to extract email address from All workbooks
(300Workbook x 10 sheets) manually seems very tough.

Any help or suggestion would be greatly Folder

Common criteria if any use (Workbooks are in a folder Named-Business) and @ symbol for email

 

[sergioMabres]

Hi Clara
Yes it is possible, you have to use VBA:
1. You put all the 300 files in a directory, only these files, manually
2. You open the files one by one with the macro
3. You have to go sheet by sheet in every file with the macro
4. You have to go on every cell, because you do not have a column with emails, with the macro
5. If the cell has an @ in its value you copy the value to a consolidation sheet with the macro
Problems that you will encounter:
a. Where would you get the names of the email you consolidate to create name email pairs.
b. Once you get this working you will need something else and another more until you get your problem totally automated by the macro, that is the hardest part.
Cheers
Sergio