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

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.

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

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.

--
Regards
PY & Associates

"rgxl" wrote in message
...
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.