+ Reply to Thread
Results 1 to 2 of 2

Merge two text files with given file location in Sheet1

  1. #1
    Registered User
    Join Date
    12-27-2018
    Location
    London, England
    MS-Off Ver
    2007, 2010
    Posts
    39

    Merge two text files with given file location in Sheet1

    Merge two text files with given file location in multiple rows in Sheet1 and save the file in another folder with the given name in column C rows respectively.

    Example:
    Cell A2: a text file1 with the given file location
    Cell B2: a text file2 with the given file location
    Cell C2: a random given file name
    With VBA merge text in Cell A2 with Cell B2 and save the file with Cell C2 given file name in a folder location given in Cell D2.

    The next cell is A3, B3, C3
    Some rows may have missing data
    Attached Images Attached Images
    Last edited by vikim; 02-24-2021 at 11:54 AM.

  2. #2
    Registered User
    Join Date
    12-27-2018
    Location
    London, England
    MS-Off Ver
    2007, 2010
    Posts
    39

    Re: Merge two text files with given file location in Sheet1

    Help me with a VBA.

+ 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. VBA Merge Files: Location Path as cell reference
    By kalyan46 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-31-2018, 11:16 AM
  2. [SOLVED] Save files with the same file name but in a different location.
    By markDuffy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-09-2017, 02:49 PM
  3. Mail merge data file location
    By Mr_Phil in forum Word Formatting & General
    Replies: 1
    Last Post: 03-13-2017, 07:03 PM
  4. split text files stored in some location to multiple files based on a condition
    By GIRISH_KH in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-01-2013, 11:32 AM
  5. merge book1,sheet1,book2,sheet1,book3,sheet1 ect
    By cfinch100 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-11-2013, 01:30 PM
  6. Textbox input as file location for data merge
    By excelman45 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-03-2010, 05:36 PM
  7. merge multiple files from text list of file pairs
    By rroach in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-14-2005, 08:17 AM

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