ulfal029
12-04-2008, 02:28 AM
I'm working with a .csv-file which I open like this:
Workbooks.OpenText Filename:="C:\abc.csv", Origin:=xlMSDOS, StartRow:=1, DataType:=xlDelimited, TextQualifier:=xlNone, ConsecutiveDelimiter:=False, Tab:=True, Semicolon:=True, Comma _ 'etc
How do I define the .csv-file as a workbook?
Dim MyFile As Workbook
MyFile = 'what do I put here?
Workbooks.OpenText Filename:="C:\abc.csv", Origin:=xlMSDOS, StartRow:=1, DataType:=xlDelimited, TextQualifier:=xlNone, ConsecutiveDelimiter:=False, Tab:=True, Semicolon:=True, Comma _ 'etc
How do I define the .csv-file as a workbook?
Dim MyFile As Workbook
MyFile = 'what do I put here?