OpenText method

  • Thread starter Thread starter Equiangular
  • Start date Start date
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.
 
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.
Click to expand...
 
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.
 
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

OpenText 1
Help using FileDialog with OpenText 1
opentext command 1
running text import wizard through c# 0
After OpenText all pastes from external apps use format from OpenText 1
"Open" or "OpenText"? 8
Open Text Method Fails 7
Workbooks.OpenText method help 3

Back
Top