atw: Re: Merging Excel workbooks

MATILDA REICH:
On Thu, 12 Apr 2007 15:53:56 +1000,  you wrote:
> Hello all,
> I have an Excel problem. Someone at work mistook me for an Excel guru. They
> want to merge 35 spreadsheets into one excel document.
> As a combined document the total rows would come to between 3,000-4,000 -
> well within Excel's capacity. 
> Excel does not appear to have the Insert File option Word does which allows 
> you to append files. 
> Searched the Help but could only find "Troubleshooting merging workbooks"
> which is no help.
>

Well, if all else fails, you could save them all as CSV files, concaternate the 
files, and then 
read the combined CSV back into Excel.   A DOS batch file with a series of
"+" commands works for the concaternation -- for example:

COPY file1.csv+file2.csv+file3.csv+file4.csv  files1_4.csv
COPY file5.csv+file6.csv+file7.csv+file8.csv files5_8.csv
COPY files1_4.csv+files5_8.csv files1_8.csv

etc...

--Peter M 

   





**************************************************
To post a message to austechwriter, send the message to 
austechwriter@xxxxxxxxxxxxxx

To subscribe to austechwriter, send a message to 
austechwriter-request@xxxxxxxxxxxxx with "subscribe" in the Subject field.

To unsubscribe, send a message to austechwriter-request@xxxxxxxxxxxxx with 
"unsubscribe" in the Subject field.

To search the austechwriter archives, go to 
www.freelists.org/archives/austechwriter

To contact the list administrator, send a message to 
austechwriter-admins@xxxxxxxxxxxxx
**************************************************

Other related posts: