Import CSV- error 53 file not found, How do I open a CSV ?

[christinelly]

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

[Logit]

Removed by author.

[Logit]

Removed by author.