| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| OpenText Method Question | Excel Programming | |||
| OpenText method not working | Excel Programming | |||
| opentext method | Excel Programming | |||
| OpenText Method | Excel Programming | |||
| How to use Opentext method with xlFixedWidth? | Excel Programming | |||
Linear Mode
