Hello,
I just started learning VBA, I am getting an error 53 when I am trying to import a CSV on my Mac.
Could someone please kindly advice what I need to do to get it to import?
Thank you so much in advance
Sub opentextfile() Dim FilePath As String FilePath = "/Users/christinekelly/Desktop/authors.csv" Open FilePath For Input As #1 row_number = 0 Do Until EOF(1) Line Input #1, LineFromFile LineItems = Split(LineFromFile, "", "") ActiveCell.Offset(row_number, 0).Value = LineItems(2) ActiveCell.Offset(row_number, 1).Value = LineItems(1) ActiveCell.Offset(row_number, 2).Value = LineItems(0) row_number = row_number + 1 Loop Close #1 End Sub



Reply With Quote
