View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
John Keith John Keith is offline
external usenet poster
 
Posts: 172
Default select new wkbk when name varies

On Mon, 12 Oct 2009 08:20:02 -0700, Patrick Molloy
wrote:

dim wb as workbook
for each wb in Workbooks
if left(wb.name,10) = "GEALLgz0ebr" then
exit for
end if
next
if not wb is nothing then
msgbox wb.name,,"workbook selected"
end if


Thanks Patrick, I'll play later tonight.


John Keith