Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Problem with Workbooks.opentext problem

  Asked By: Gin    Date: Sep 22    Category: MS Office    Views: 1845
  

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?

Share: 

 

No Answers Found. Be the First, To Post Answer.

 
Didn't find what you were looking for? Find more on Problem with Workbooks.opentext problem Or get search suggestion and latest updates.




Tagged: