Prev: Office 2007 on a new PC?
Next: Office 2003 installation problem - not a valid Win32 application
From: Stanislav on 6 Mar 2010 04:18
It is possible to take advantage of the special software for such purposes - MergeExcel



J wrote:

Merge Excel Documents
27-Aug-07

I am trying to merge multiple excel spreadsheets in regular or CSV format so
I don't have to copy and paste each and every file into one document. The
problem I am experiencing is that the "compare and merge workbooks" is not
highlighted and I cannot access that feature in Excel 2003. Does anybody
know how I can get access to that feature or recommend an altnerative
solution. Thanks.

-J.R.

Previous Posts In This Thread:

On Monday, August 27, 2007 10:30 AM
J wrote:

Merge Excel Documents
I am trying to merge multiple excel spreadsheets in regular or CSV format so
I don't have to copy and paste each and every file into one document. The
problem I am experiencing is that the "compare and merge workbooks" is not
highlighted and I cannot access that feature in Excel 2003. Does anybody
know how I can get access to that feature or recommend an altnerative
solution. Thanks.

-J.R.

On Monday, August 27, 2007 3:13 PM
Bob I wrote:

If the CSV files all have exactly the same fields and no headers, you can do a
If the CSV files all have exactly the same fields and no headers, you
can do a "copy file1.csv + file2.csv + file3.csv allfiles.csv" at the
command prompt to concatenate them.

COPY /? to see usage particulars.

J.R. wrote:

On Monday, August 27, 2007 9:14 PM
J.R. wrote:

Hi Bob, thanks for the info.
Hi Bob,
thanks for the info. I take it you are talking about using DOS or
something similar since you mentioned command prompts.



"J.R." wrote:

On Tuesday, August 28, 2007 2:53 PM
Bob I wrote:

Command Prompt is the NT version of "DOS".
Command Prompt is the NT version of "DOS". You may find the shortcut to
start it Programs, Accessories.

J.R. wrote:

On Thursday, August 30, 2007 9:32 AM
J wrote:

Do you have any idea how I can use the command within excel?
Do you have any idea how I can use the command within excel? I find it odd
that I cannot access the ability.

"Bob I" wrote:

On Thursday, August 30, 2007 10:38 AM
Bob I wrote:

No, not "within Excel". I gave you the simple way to do it at a command prompt.
No, not "within Excel". I gave you the simple way to do it at a command
prompt. If you want to do it from inside Excel, take a look at Data,
Import external data. Or you could record a Macro, or you could do it in
VBA. If that's the case, pose your question ove in the Excel group, and
be prepared to explain in detail what you want to do and the files you
want to do it with.

J.R. wrote:


Submitted via EggHeadCafe - Software Developer Portal of Choice
Dr. Dotnetsky's Cool .Net Tips and Tricks No. 26
http://www.eggheadcafe.com/tutorials/aspnet/8e390106-20d1-4b2b-be30-cde5d852348d/dr-dotnetskys-cool-net.aspx
 | 
Pages: 1
Prev: Office 2007 on a new PC?
Next: Office 2003 installation problem - not a valid Win32 application