View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ricky Ricky is offline
external usenet poster
 
Posts: 3
Default "For each w in workbooks "can't find ".dat" open excel sheets,

I use "for each w in workbooks --- Next w" to find all open workbooks. It
doesn't seem to find .dat files opened in excel, but will find .csv files
opened in excel. How do I find all open files that have been opened by
excel2007? It seems to work fine on older excel software.