VBA help with opening and checking workbooks

[eHanSolo]

Hi all,

I basically need to check through a whole barrage of excel workbooks for (let's say) "wcm11" and if there are any workbooks with this then i'd like to add "bla bla" to a specified cell. At the moment, i just need to search for "wcm11" but I will have to do the same for more.

Any handy hints would be extremely appreciated!!

Thank you in advance.

 

[PHV]

Have you tried to play with the macro recorder ?

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[eHanSolo]

Tried that PHV...using the recorder gives me sub-standard code...


Any more takers out there???

 

[javanic]

The macro recorder does produce nasty code, but I often use it to get me started with a particular task. If you got the macro to do what you want, then you may be able to generalize (and clean up) the code to accomplish your task.

- javanic -