View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Darla
 
Posts: n/a
Default Open many workbooks in Excel & print one page

I have 80 workbooks that I need to open and print the summary tab for each
one and then close. Does anyone know how I could do this all at one time?
Is there some kind of macro that would work for this? I am a novice with
macros but would be willing to try but not sure how to begin.

Thank you for your help.