CSV variable type

[Kinseres]

Hi all!

I have a UDF that I utilise when I need to repetitively copy/paste multiple data ranges between two excel workbooks.

Sub ACopyPasta(CopyBook As Workbook, CopySheet As String, CopyRange As String, PasteBook As Workbook, PasteSheet As String, PasteRange As String, Optional transpose As Boolean = False)

Set CSheet = CopyBook.Sheets(CopySheet)
    CSheet.Activate
    CSheet.Range(CopyRange).Select
    Selection.Copy
    PasteBook.Activate
    PasteBook.Sheets(PasteSheet).Select
    Range(PasteRange).PasteSpecial xlPasteValues, transpose:=transpose
End Sub

The idea being that I can just call the function each time I need to perform a copy/paste, defining the variables as I go. It just keeps my main code from getting too cluttered.

This works perfectly fine with standard excel workbooks, but I cannot for the life of me get this working when the CopyBook is to be a CSV file, I just get a "ByRef argument type mismatch" at compile.

Does anybody know what variable type I should be using instead there? Google as failed me!