Hello Guys,
I'm very new to VBA programming, and need some help in learning on how / or if the below workflow can be improved.
In order to reduce the manual work that i am put to do, i am searching for a macro that can search for a string in multiple excel files with multiple sheets from a shared drive on my network. The files are constantly updated, that's why the search should be made from a shared drive.
The result should also enumerate all the excel files that we're searched and in case of hits it should point out XLS file/ xls sheet/ and the column or cell.
Ideally, after the above will be sorted out, i will look for a way in instructing Office in doing the following:
1. Printscreen with the result
2. New Worddocument and paste printscreen
3. Save document in a specified by me network path with the following name "String name/dateofsearch''.doc
Is this doable?
Really appreciate the help/guiding.
Bookmarks