OpenText method

E

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.
 
D

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.
 
E

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.
 
D

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top