-
Solved: Defining .csv-file as workbook
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]
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules