OpenText method

[Equiangular]

Hello,

I want to use OpenText to parse a tab delimited file, delete some rows
and then save as a new xls. However, OpenText does not return a
reference to the opened text file. Is there any better way to get the
reference apart from using ActiveWorkbook?

Thanks.

 

[Dave Peterson]

That's what I'd do.

Hello,

I want to use OpenText to parse a tab delimited file, delete some rows
and then save as a new xls. However, OpenText does not return a
reference to the opened text file. Is there any better way to get the
reference apart from using ActiveWorkbook?

Thanks.

 

[Equiangular]

I wonder if there's any problem if the user is editing other opened
workbooks and the text file to be parsed is quite large.

 

[Dave Peterson]

The text file will be the activeworkbook right after you open it.

I've never had any trouble doing this kind of thing.

 

[Equiangular]

OK

The text file will be the activeworkbook right after you open it.

I've never had any trouble doing this kind of thing.