Consulting

Results 1 to 5 of 5

Thread: How to merge two different csv files by Macro

  1. #1
    VBAX Newbie
    Joined
    Sep 2024
    Posts
    2
    Location

    How to merge two different csv files by Macro

    Hello ,
    i need a help .
    i have two csv files
    the first csv file contains a table , each column seperates with ;
    the second csv file contains a table ,each column seperates with ,

    i would like to have a macro vba script to let user to enter the input file path of csv and also choose the output folder path then click on button to run the script and get the output file

    my files :
    https://www.mediafire.com/folder/wyj8nir5mbb5p/data

    first csv.jpgsecond csv.jpgoutput.jpg
    Last edited by Soly_90; 09-05-2024 at 01:58 PM.

  2. #2
    Moderator VBAX Wizard Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    5,213
    Location
    Welcome to VBAX Soly_90. Did you by any chance post this issue elsewhere?
    Remember To Do the Following....
    Use [Code].... [/Code] tags when posting code to the thread.
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link

  3. #3
    VBAX Newbie
    Joined
    Sep 2024
    Posts
    2
    Location
    I have asked in somewhere else but I did not get the solution .so I have asked here ,if someone could solve my issue ?

  4. #4
    Administrator VBAX Master georgiboy's Avatar
    Joined
    Mar 2008
    Location
    Kent, England
    Posts
    1,252
    Location
    Hi Soly_90,

    Can I recommend that you read the 'What is multiposting' of the below link:
    http://www.vbaexpress.com/forum/faq...._new_faq_item3

    It is a rule of most (if not all) Excel forums that if you post the same question on more than one forum, you should post a link to the other forums. The below link will explain why you should do this in more detail:
    https://excelguru.ca/a-message-to-forum-cross-posters/
    Click here for a guide on how to add code tags
    Click here for a guide on how to mark a thread as solved
    Click here for a guide on how to upload a file with your post

    Excel 365, Version 2408, Build 17928.20080

  5. #5
    VBAX Mentor
    Joined
    Nov 2022
    Location
    The Great Land
    Posts
    371
    Location
    Advise you zip files with Windows Compression and attach to post.
    How to attach file: Reading and Posting Messages (vbaexpress.com), click Go Advanced below post edit window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Tags for this Thread

Posting Permissions

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