View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
drabbacs drabbacs is offline
external usenet poster
 
Posts: 11
Default multi-file open to one workbook

I believe there is a shortcut method for opening/copying
several seperate excel files into one workbook, but I
don't recall the trick.

There are 40+ files which I would like to copy into one
workbook with each file's info on it's own sheet within
the new workbook.

If anyone knows the trick or knows where I can find it on
the web, I'd appreciate them sharing their info.

Thanks in advance,
Drabbacs