Solved: Defining .csv-file as workbook

[ulfal029]

I'm working with a .csv-file which I open like this:

[vba]Workbooks.OpenText Filename:="C:\abc.csv", Origin:=xlMSDOS, StartRow:=1, DataType:=xlDelimited, TextQualifier:=xlNone, ConsecutiveDelimiter:=False, Tab:=True, Semicolon:=True, Comma _ 'etc
[/vba]

How do I define the .csv-file as a workbook?

[vba]Dim MyFile As Workbook
MyFile = 'what do I put here?[/vba]

[mdmackillop]

[VBA]Sub OpenCsv()
Dim MyFile As Workbook
Set MyFile = Workbooks.Open(Filename:="C:\abc.csv")
MsgBox MyFile.Sheets.Count
End Sub
[/VBA]

[ulfal029]

Since the .csv-file is already open, I used
[VBA]Dim MyFile As WorkBook
Set MyFile = Workbooks("abc.csv")[/VBA]
And it worked fine.