+ Reply to Thread
Results 1 to 4 of 4

Importing multiple files into Excel so they show up one after the other.

  1. #1
    Registered User
    Join Date
    08-26-2013
    Location
    Winchester, KY
    MS-Off Ver
    Excel 2010
    Posts
    2

    Post Importing multiple files into Excel so they show up one after the other.

    Hello,

    I am trying to modify an existing code so that instead of importing a file and it replacing what is already there, I would like to import a file and allow it to be added to the last line of the existing file.

    The code that I have now is:

    Please Login or Register  to view this content.
    I'm not sure where to start to make this change happen.
    Last edited by catacry; 08-26-2013 at 03:15 PM.

  2. #2
    Forum Contributor
    Join Date
    01-17-2013
    Location
    Belgium
    MS-Off Ver
    Excel 2010
    Posts
    211

    Re: Importing multiple files into Excel so they show up one after the other.

    replace your code at bottom
    Please Login or Register  to view this content.
    with this code
    Please Login or Register  to view this content.
    If solved remember to mark Thread as solved , to mark your thread as Solved select Thread Tools and click Mark thread as Solved.

    I can't read the mind of my wife so then I get picture but no sound .... and then I mostly get the idea, same goes here picture your outcome and I get the idea.

  3. #3
    Registered User
    Join Date
    08-26-2013
    Location
    Winchester, KY
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Importing multiple files into Excel so they show up one after the other.

    Unfortunately I am getting a type mismatch error and I cannot locate the cause of this error.

  4. #4
    Forum Contributor
    Join Date
    01-17-2013
    Location
    Belgium
    MS-Off Ver
    Excel 2010
    Posts
    211

    Re: Importing multiple files into Excel so they show up one after the other.

    is it possible to provide a copy of your file (make sure to remove any info you do not want to share, also check file properties, prior to uploading)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Importing Multiple txt files in excel
    By celiojr in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-08-2013, 11:00 AM
  2. Replies: 0
    Last Post: 11-27-2012, 01:43 PM
  3. Opening multiple files and importing into Excel
    By macka1987 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-11-2011, 04:55 PM
  4. Importing multiple excel files into 1
    By vascobmcastro in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-25-2010, 01:29 PM
  5. [SOLVED] Importing from multiple Excel files
    By Tired of wasting time in forum Excel General
    Replies: 2
    Last Post: 09-21-2005, 04:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1