excel vba open

[adnan2004]

What is the difference between open method and opentext  method members of the workbooks object

where the first also opens text files

[#2 · Accepted solution]

@adnan2004 

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.

[#3]

thanks a lot