Hi everyone,

I was looking for a way to batch import CSV files from a folder, and have them appear as separate worksheets in an Excel file.

Here is the specific code I'm using (I got the original code from sites.madrocketscientist.com/jerrybeaucaires-excelassistant/merge-functions/csvs-to-sheets). This code is created for Windows, however I'm hoping someone can help me get it working for Mac!
Option Explicit
Sub ImportCSVs()
'Author:    Jerry Beaucaire
'Date:      8/16/2010
'Summary:   Import all CSV files from a folder into separate sheets
'           named for the CSV filenames
'Update:    2/8/2013   Macro replaces existing sheets if they already exist in master workbook
Dim fPath As String
Dim fCSV As String
Dim wbCSV As Workbook
Dim wbMST As Workbook

Set wbMST = ThisWorkbook
fPath = "/Users/RSM/Desktop/CSV/"                  'path to CSV files
Application.ScreenUpdating = False  'speed up macro
Application.DisplayAlerts = False   'no error messages, take default answers
fCSV = Dir(fPath & "*.csv")         'start the CSV file listing

    On Error Resume Next
    Do While Len(fCSV) > 0
        Set wbCSV = Workbooks.Open(fPath & fCSV)                    'open a CSV file
        wbMST.Sheets(ActiveSheet.Name).Delete                       'delete sheet if it exists
        ActiveSheet.Move After:=wbMST.Sheets(wbMST.Sheets.Count)    'move new sheet into Mstr
        Columns.AutoFit             'clean up display
        fCSV = Dir                  'ready next CSV
    Loop
  
Application.ScreenUpdating = True
Set wbCSV = Nothing
End Sub
Any help would be greatly appreciated!!

Thanks in advance
RSM