Forum Discussion
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.
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
