View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
stevec stevec is offline
external usenet poster
 
Posts: 177
Default Select Window Containing specific text

I have a line of code that looks like this:

Windows("Bannana -- 2007 07 31.xls").Activate

How do I change this to activiate any workbook that contains the name
"bannana"?

thanks...