Forum Discussion
Solved
excel vba open
What is the difference between open method and opentext method members of the workbooks object
where the first also opens text files
Workbooks.Open does let you open a text file, but you won't have any control over how it opens.
Workbooks,OpenText has a series of arguments that let you specify how to process the text file:
- Is it delimited or fixed width
- What is the data type of each column
- And more.
2 Replies
Workbooks.Open does let you open a text file, but you won't have any control over how it opens.
Workbooks,OpenText has a series of arguments that let you specify how to process the text file:
- Is it delimited or fixed width
- What is the data type of each column
- And more.
- thanks a lot
