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: 1806

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

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?



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.