VBA, Excel or VB (not .NET)

Posted on 2006-04-23
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
    LVL 6

    Accepted Solution

    Take a look at this EE solution.  It will get you started in the right direction:

    Author Comment

    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 :)

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Suggested Solutions

    Title # Comments Views Activity
    tenRun challenge 28 67
    mergeTwo  challenge 13 53
    wordlen challenge 3 28
    pairs challenge 5 29
    Go is an acronym of golang, is a programming language developed Google in 2007. Go is a new language that is mostly in the C family, with significant input from Pascal/Modula/Oberon family. Hence Go arisen as low-level language with fast compilation…
    This article will show, step by step, how to integrate R code into a R Sweave document
    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 …
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    737 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

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now