Import CSV- error 53 file not found, How do I open a CSV ?
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
HTML Code:
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
