View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sharman sharman is offline
external usenet poster
 
Posts: 11
Default Activating / Closing workbook using part name and a wild character

Hi,

Is it possible to activate/close an open workbook by a macro by using just
the part name alongwith with a wild character? Like if the workbook name is
"NewBook_6_10" and I want to activate/close it by just using "New*". I
tried using it but I get an error message. Thanks in advance.