VBA, Excel or VB (not .NET)

Posted on 2006-04-23
Medium Priority
Last Modified: 2010-04-17

I have several excel files named seq. 1,2,3..N; containing the same col names, I need to use a macro or VB appl. to open new execl and extract the data from sheet1 from each excel file and put it in sheet1 of the new excel file.

I need to ask for the first & last excel file name every time I want to do that.

Question by:AbuMariam

Accepted Solution

JRossi1 earned 1000 total points
ID: 16524104
Take a look at this EE solution.  It will get you started in the right direction:  http://www.experts-exchange.com/Applications/MS_Office/Q_20673526.html?query=excel+combine+spreadsheets&clearTAFilter=true#8888616

Author Comment

ID: 16531607
Thanks Rossi,

Last night I worked on the problem and solve it using VB6, but this macro is much easier and nice looking.

The issue here is the HEADER col. in each excel file we are combining, the lazy users want to remove it automatically.

Any help in this regard.

Dear Moderator,
I would like to separate the points between "JRossi1" and the original solver "smozgur".

JRossi, I hope you do not mind :)

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this post we will learn how to make Android Gesture Tutorial and give different functionality whenever a user Touch or Scroll android screen.
What do responsible coders do? They don't take detrimental shortcuts. They do take reasonable security precautions, create important automation, implement sufficient logging, fix things they break, and care about users.
An introduction to basic programming syntax in Java by creating a simple program. Viewers can follow the tutorial as they create their first class in Java. Definitions and explanations about each element are given to help prepare viewers for future …
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question