+ Reply to Thread
Results 1 to 3 of 3

Import Data From Multiple Files Selected By User

  1. #1
    Registered User
    Join Date
    05-26-2019
    Location
    UK
    MS-Off Ver
    2016
    Posts
    50

    Import Data From Multiple Files Selected By User

    Hello, copying data from a file, or several, when they've different names is not a problem, however, how do I copy data from multiple files (and paste it all one under another) when the names are different each time? The layout inside (columns A to Z) never change though.
    It's not possible to specify file names since it'd cause too much manual work.

    In short, e.g. a user selects 10 files and their contents are imported on a last row +1 basis.

    Your help is greatly appreciated.

    Many thanks!

  2. #2
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    1,701

    Re: Import Data From Multiple Files Selected By User

    You can use code like the following to select multiple files:

    Please Login or Register  to view this content.

  3. #3
    Forum Expert Kenneth Hobson's Avatar
    Join Date
    02-05-2007
    Location
    Tecumseh, OK
    MS-Off Ver
    Office 365, Win10Home
    Posts
    2,575

    Re: Import Data From Multiple Files Selected By User

    Have you tried recording a macro? Maybe see if consolidate method will record. It is then a simple matter to modify it to let the user select files to automate the imports.

    https://support.microsoft.com/en-us/...5-a0b2c9e36d9b

    Depending on the data, other methods would work too.

    Attaching a simple example can help us help more easily.

+ 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. Import data from multiple standardised files?
    By aggelospa in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-02-2017, 09:38 AM
  2. Import data from multiple files
    By Danno82 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-30-2014, 01:33 AM
  3. [SOLVED] A loop to import text files one by one until cancel has been selected by the user.
    By kokapelly in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-31-2014, 12:27 PM
  4. [SOLVED] Macro to Import Multiple TXT Files into workbook - User to select files/directory
    By saber007 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-15-2013, 08:43 PM
  5. [SOLVED] Import user selected columns from a text file
    By aarho in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-11-2012, 08:28 PM
  6. import data from .txt file selected by user
    By ahartman in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-29-2008, 03:34 AM
  7. [SOLVED] Import data from multiple excel files
    By Arlan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-22-2005, 04:25 PM

Tags for this Thread

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