Is there a way to create individual files from a multi sheet excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am new to Excel 2007 and I have a couple of questions. Often I need to
send users an excel file that contains multiple sheets of information. These
multiple sheets come from indivisdual excel documents that I copy into one
document. Is there a way to quickly create one large excel document from
multiple excel documents and have each individual file be a separate sheet?
Also if the reverse is possible, that would be great. Essentially saving
individual sheets as separate either excel or tab deliminated text files
would be extremely helpful.
 
Essentially we would in a new file (Thisworkbook);
list all individual files in a column;
in a loop,
open each file,
copy the sheet that you want,
paste in a new sheet in Thisworkbook;
close the file;
loop
save Thisworkbook in a new name.

The reverse is not much different.
 
Back
Top