Results 1 to 11 of 11

Import multiple semicolon separated csv files

Threaded View

Ivodv Import multiple semicolon... 06-14-2010, 05:44 AM
arthurbr Re: Import multiple semicolon... 06-14-2010, 05:48 AM
abousetta Re: Import multiple semicolon... 06-14-2010, 05:53 AM
Ivodv Re: Import multiple semicolon... 06-14-2010, 06:37 AM
snb Re: Import multiple semicolon... 06-14-2010, 06:50 AM
abousetta Re: Import multiple semicolon... 06-14-2010, 07:02 AM
Ivodv Re: Import multiple semicolon... 06-14-2010, 09:30 AM
snb Re: Import multiple semicolon... 06-14-2010, 09:45 AM
abousetta Re: Import multiple semicolon... 06-14-2010, 11:18 AM
timepass_2 Re: Import multiple semicolon... 12-07-2012, 06:35 AM
abousetta Re: Import multiple semicolon... 12-07-2012, 08:17 AM
  1. #1
    Registered User
    Join Date
    06-14-2010
    Location
    Amsterdam, Netherlands
    MS-Off Ver
    Excel 2007
    Posts
    3

    Import multiple semicolon separated csv files

    Guys,

    After several hours of ‘googling’, my hopes are on you for solving my VBA csv-import problem. The problem is the following:

    I’m trying to import several semicolon separated .csv files in one Excel worksheet (multiple tabs). The import works fine, but the separation in different columns doesn’t go well. The most solutions I found work fine for one csv file, but don’t work in my code:


    Sub csv()
    
    Dim oWbk As Workbook
    Dim sFil As String
    Dim sPath As String
    
    sPath = "C:\ \csv\" 'location of files
    ChDir sPath
    sFil = Dir("*.csv") 'all csv-files in the folder have to be imported
    Do While sFil <> ""  ‘starts LOOP until all files in folder sPath have been looped through
    Set oWbk = Workbooks.Open(sPath & "\" & sFil) 'opens the file
    
    oWbk.Close True 'close the workbook, saving changes
    sFil = Dir
    Loop ' End of LOOP
    
    End Sub


    Who can help me out? Your advice is truly appreciated!
    Ivo
    Last edited by pike; 06-14-2010 at 05:48 AM. Reason: Add tags for newbie

Thread Information

Users Browsing this Thread

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

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