I am facing very typical kind of problem with using workbooks.opentext method in
VB.NET.

Actually i am having more than 500 text files. And i need to convert them into
csv file using opentext method. But the problem is that in many of text files if
directly convert using following method

ExcelAll.Workbooks.OpenText(FileName:=FileNm & ".txt", Origin:=437, StartRow:=1,
DataType:=xlTextParsing.xlFixedWidth, TrailingMinusNumbers:=True)

then data of some columns mixed with each other. So i want one common code for
opentext method using which all the text files should be converted in to csv
files without mixing of columns.

I also used filedinfo method, but it looks like a static method.

Can any one suggest me any idea?