Here's what I currently use (which works, but I'd prefer getting the data without windows flickering / files opening and closing, etc). I just want to copy columns A:N from the closed CSV and paste them to columns A:N in the sheet named "CSV_paste" of the active workbook. (It would also be fine if the code copied a range like "A1:N500" if grabbing the entire columns is problematic...though I don't see why it would be.)
Code:
Sub Macro_1()
Workbooks.Open Filename:="C:\Users\Desktop\port_export.csv"
Columns("A:N").Copy
ThisWorkbook.Activate
With Sheets("CSV_paste")
.Range("A:N").PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End With
Application.CutCopyMode = False
Windows("port_export.csv").Close
End Sub