View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Marcotte A Marcotte A is offline
external usenet poster
 
Posts: 66
Default For....each w/ workbook files

TYVM. God Bless MVPs. :)

"Ron de Bruin" wrote:

Sure
http://www.rondebruin.nl/copy4.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Marcotte A" wrote in message
...
Thanks Ron. Your code is a little over my head, but it seems to require
either hard-coding the file names or getting user input (via
GetOpenFileName). Is there not a way to open all the files in a directory
(either one at a time or at the same time)?