View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Valeria[_2_] Valeria[_2_] is offline
external usenet poster
 
Posts: 24
Default for-each-next loop

Dear experts,
I would like to open through a macro each of the workbooks
that are in a certain folder. (Their number and names can
vary over time).
I wanted to use the FOR EACH... IN... NEXT loop, but it
does not seem to work (I get a "Type mismatch" error
message). Do you know how I could perform this?
Many thanks in advance.
Regards,
Valeria