View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
mudraker[_189_] mudraker[_189_] is offline
external usenet poster
 
Posts: 1
Default Looping though *.xls files except for the main consolidation file

You almost have it

with you attempt code change

If Basebook.Name = FNames Then


to

If Basebook.Name = FNames.Name The

--
Message posted from http://www.ExcelForum.com