OpenText method
 

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.

OpenText method
 

That's what I'd do.

Equiangular wrote:

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

OpenText method
 

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 wrote:
That's what I'd do.

Equiangular wrote:
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.

OpenText method
 

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

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

Equiangular wrote:

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 wrote:
That's what I'd do.

Equiangular wrote:
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

OpenText method
 

OK

Dave Peterson wrote:
The text file will be the activeworkbook right after you open it.

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

Equiangular wrote:
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 wrote:
That's what I'd do.

Equiangular wrote:
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.