Where can I find the Text Import Wizard?

R

Roadie

Hi,

I have some files I want to open in Excel (2000). The files contai
text and numbers, separated by delimiter "|". If I open them in Excel
I don't get the Text Import Wizard and I can't define the delimiter
All the information is pasted in column A.
The only way I can get the information separated in the right way, i
by using Data -> Get External Data -> Import Text File. That way, th
Text Import Wizard is launched and I can choose Delimited/Fixed Widt
and the delimiter.

Does anyone know how I can get the Text Import Wizard to launch when
open the file with File -> Open?

TIA,

Anne
 
R

Roadie

I've already found a solution for my problem:
Workbooks.OpenText Filename:="file.001", DataType:=xlDelimited
Other:=True, Otherchar:="|".

I still don't see the Text Import Wizard, but for this moment m
problem is solved. However, if anyone knows if there is a way to launc
the Text Import Wizard when opening files, I'm still interested
 
D

Dave Peterson

I've never not seen excel pop up that wizard whenever I open a text file.

I just created a file with the name edit2.001 and did a file|open inside xl2002
and the wizard popped up.

When you open this file, what happens to the data? Does it all go in column A?

If yes, then you could use Data|text to columns.

(But that doesn't explain why you don't get the wizard to pop up.)

What happens if you rename the *.001 file to *.txt?

=====

Ok, I got a guess!

Maybe the .001 extension is being treated just like .csv.

Can you look at your file assocations in windows to see how .001 is set.

In win98, I can do this within Windows Explorer:
View|Folder Options|File Types Tab
Scroll down looking for .001 to see what it's associated with that extension.

=====
One option that might fix it:

I'm not sure if this will work. It's useful to make excel regain any extension
that it lost.

You can reregister excel.

Close Excel and
Windows Start Button|Run
excel /unregserver
then
Windows Start Button|Run
excel /regserver

The /unregserver & /regserver stuff resets the windows registry to excel's
factory defaults

================
If that didn't work, maybe just associate .001 files with notepad.

Inside windows explorer once more, locate your .001 file.
shift-rightclick on it and choose "Open With"
Select NotePad (or browse for it--usually in your windows/winnt folder)
and make sure you check that box at the bottom -- to always use this program.
 
R

Roadie

Dave said:
*I've never not seen excel pop up that wizard whenever I open a tex
file.

I just created a file with the name edit2.001 and did a file|ope
inside xl2002
and the wizard popped up.

When you open this file, what happens to the data? Does it all go i
column A?

If yes, then you could use Data|text to columns.

(But that doesn't explain why you don't get the wizard to pop up.)

What happens if you rename the *.001 file to *.txt?*
Click to expand...
The data all goes into column A and the Data->Text to Columns work
fine indeed. After renaming to .txt the data is treated in the sam
way, all pasted in column A.

Dave said:
*Ok, I got a guess!

Maybe the .001 extension is being treated just like .csv.

Can you look at your file assocations in windows to see how .001 i
set.

In win98, I can do this within Windows Explorer:
View|Folder Options|File Types Tab
Scroll down looking for .001 to see what it's associated with tha
extension.

=====
One option that might fix it:

I'm not sure if this will work. It's useful to make excel regain an
extension
that it lost.

You can reregister excel.

Close Excel and
Windows Start Button|Run
excel /unregserver
then
Windows Start Button|Run
excel /regserver

The /unregserver & /regserver stuff resets the windows registry t
excel's
factory defaults*
Click to expand...
It's not just 001 that is the problem. Actually, the filenames are lik
'GFM02.T000047526', 'GFM02.T000047525' and so on. However, renamin
them doesn't change anything in the way Excel opens them. I can'
predict the names, so changing the file associations is no use.

Dave said:
*If that didn't work, maybe just associate .001 files with notepad.

Inside windows explorer once more, locate your .001 file.
shift-rightclick on it and choose "Open With"
Select NotePad (or browse for it--usually in your windows/winn
folder)
and make sure you check that box at the bottom -- to always use thi
program. *
Click to expand...
I probably have to process these files twice a week, so I would like t
use a macro. Therefore, using Notepad doesn't seem very usefull to me
I think I'll use the Text to Columns or use a macro to open the files.

Thanks very much.

Greetings from the Netherlands,

Anne
 
D

Dave Peterson

I didn't actually mean to use Notepad for anything other as the owner of that
extension. I didn't mean to use it to edit your data.

But if I were doing this repetitively, I'd use a macro, too.

Sorry none of my suggestions panned out.
 
M

MPeterson

Annet -

I am having the exact same problem. By chance have you found a solution

Best, Meg
 
Top