View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Belinda & Jamie Belinda & Jamie is offline
external usenet poster
 
Posts: 1
Default Apply macro to closed workbooks

Is there any way that I can apply a recorded macro to a selection of Excel
files, without having to open each one?
ie. I have created a macro to copy particular cells to a new worksheet and I
want to copy the same cells from about 240 spreadsheets onto a new sheet,
but don't want to have to open each one up...

Thanks in advance.
Belinda