PC Review


Reply
Thread Tools Rate Thread

Desire to Open TXT File With Excel, File Association Not Working

 
 
=?Utf-8?B?UmljayBIYW1pbHRvbg==?=
Guest
Posts: n/a
 
      28th Mar 2007
I have tried to associate TXT files with Excel, it's not working. Steps to
date:
1. Open Windows Explorer
2. Right click a .TXT file
3. Click "Open With"
4. Click "Choose Program"
5. Click Browse
6. Click to EXCEL.EXE path, which is C:\Program Files\Microsoft
Office\Office11\
7. Click on EXCEL.EXE
8. Click on checkbox to mark, Always Use The Selected Program...
9. Click OK.

The system continues to open the TXT file with Notepad. If I right-click
the file in Windows Explorer, then click Open With, it does NOT, after doing
the above, even SHOW Excel as an option.

I have tried the DOS command, ASSOC=.TXT= (space)
to delete the association of a TXT file to notepad, but that will not work.
Help! Thanks.

Rick


 
Reply With Quote
 
 
 
 
JockoBailey
Guest
Posts: n/a
 
      28th Mar 2007

"Rick Hamilton" <(E-Mail Removed)> wrote in message
news:E01AB44D-0C3F-436D-B6AB-(E-Mail Removed)...
> I have tried to associate TXT files with Excel, it's not working. Steps

to
> date:
> 1. Open Windows Explorer
> 2. Right click a .TXT file
> 3. Click "Open With"
> 4. Click "Choose Program"
> 5. Click Browse
> 6. Click to EXCEL.EXE path, which is C:\Program Files\Microsoft
> Office\Office11\
> 7. Click on EXCEL.EXE
> 8. Click on checkbox to mark, Always Use The Selected Program...
> 9. Click OK.
>
> The system continues to open the TXT file with Notepad. If I right-click
> the file in Windows Explorer, then click Open With, it does NOT, after

doing
> the above, even SHOW Excel as an option.
>
> I have tried the DOS command, ASSOC=.TXT= (space)
> to delete the association of a TXT file to notepad, but that will not

work.
> Help! Thanks.
>
> Rick
>
>

Add or change to Excel.exe in this key

HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExt
s\.txt\OpenWithList


 
Reply With Quote
 
=?Utf-8?B?UmljayBIYW1pbHRvbg==?=
Guest
Posts: n/a
 
      28th Mar 2007
EXCEL.EXE is already in the list. Name=b, Type=REG_SZ, DATA=EXCEL.EXE

NOTEPAD.EXE is the first value. Any other suggestions? Thanks!

Rick

"JockoBailey" wrote:

>
> "Rick Hamilton" <(E-Mail Removed)> wrote in message
> news:E01AB44D-0C3F-436D-B6AB-(E-Mail Removed)...
> > I have tried to associate TXT files with Excel, it's not working. Steps

> to
> > date:
> > 1. Open Windows Explorer
> > 2. Right click a .TXT file
> > 3. Click "Open With"
> > 4. Click "Choose Program"
> > 5. Click Browse
> > 6. Click to EXCEL.EXE path, which is C:\Program Files\Microsoft
> > Office\Office11\
> > 7. Click on EXCEL.EXE
> > 8. Click on checkbox to mark, Always Use The Selected Program...
> > 9. Click OK.
> >
> > The system continues to open the TXT file with Notepad. If I right-click
> > the file in Windows Explorer, then click Open With, it does NOT, after

> doing
> > the above, even SHOW Excel as an option.
> >
> > I have tried the DOS command, ASSOC=.TXT= (space)
> > to delete the association of a TXT file to notepad, but that will not

> work.
> > Help! Thanks.
> >
> > Rick
> >
> >

> Add or change to Excel.exe in this key
>
> HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExt
> s\.txt\OpenWithList
>
>
>

 
Reply With Quote
 
Ghostrider
Guest
Posts: n/a
 
      28th Mar 2007

Rick Hamilton wrote:

> EXCEL.EXE is already in the list. Name=b, Type=REG_SZ, DATA=EXCEL.EXE
>
> NOTEPAD.EXE is the first value. Any other suggestions? Thanks!
>
> Rick
>
> "JockoBailey" wrote:


This question might have been better addressed and answered in a MS
Office or Excel newsgroup instead of here. AFAIK, the default app for
opening *.txt files is Notepad. Notwithstanding this statement, *.txt
files can be opened from within Excel itself. However, it goes into a
parsing box to separate the text fields and text. This is simply the
generic programming for most spreadsheet programs...they are not (and
were not) designed to handle an entire *.txt file within a single cell.
Instead, spreadsheet applications can (and will) search for delimiters
that puts text into their proper columns, rows and cells.
 
Reply With Quote
 
=?Utf-8?B?UmljayBIYW1pbHRvbg==?=
Guest
Posts: n/a
 
      28th Mar 2007
Dear G,

I know exactly how Excel handles TXT files, I push tab-delimited text files
into Excel every day, and they parse perfectly, so this is NOT an Excel
question. It's a Windows question, because I cannot get EXCEL to be listed
in the list of programs which XP presents. when you right-click the file and
choose open with. It's an XP bug, IMHO. Suggestions?

r.

"Ghostrider" wrote:

>
> Rick Hamilton wrote:
>
> > EXCEL.EXE is already in the list. Name=b, Type=REG_SZ, DATA=EXCEL.EXE
> >
> > NOTEPAD.EXE is the first value. Any other suggestions? Thanks!
> >
> > Rick
> >
> > "JockoBailey" wrote:

>
> This question might have been better addressed and answered in a MS
> Office or Excel newsgroup instead of here. AFAIK, the default app for
> opening *.txt files is Notepad. Notwithstanding this statement, *.txt
> files can be opened from within Excel itself. However, it goes into a
> parsing box to separate the text fields and text. This is simply the
> generic programming for most spreadsheet programs...they are not (and
> were not) designed to handle an entire *.txt file within a single cell.
> Instead, spreadsheet applications can (and will) search for delimiters
> that puts text into their proper columns, rows and cells.
>

 
Reply With Quote
 
Bob I
Guest
Posts: n/a
 
      28th Mar 2007
Just R-click txt file and pick Open With, Choose Program, Browse, get
Excel.exe and pop the Always use box. test it. Now go back to Open with
and change the Always open with back to Notepad if you want, but the
Excel will stay.

Rick Hamilton wrote:

> Dear G,
>
> I know exactly how Excel handles TXT files, I push tab-delimited text files
> into Excel every day, and they parse perfectly, so this is NOT an Excel
> question. It's a Windows question, because I cannot get EXCEL to be listed
> in the list of programs which XP presents. when you right-click the file and
> choose open with. It's an XP bug, IMHO. Suggestions?
>
> r.
>
> "Ghostrider" wrote:
>
>
>>Rick Hamilton wrote:
>>
>>
>>>EXCEL.EXE is already in the list. Name=b, Type=REG_SZ, DATA=EXCEL.EXE
>>>
>>>NOTEPAD.EXE is the first value. Any other suggestions? Thanks!
>>>
>>>Rick
>>>
>>>"JockoBailey" wrote:

>>
>>This question might have been better addressed and answered in a MS
>>Office or Excel newsgroup instead of here. AFAIK, the default app for
>>opening *.txt files is Notepad. Notwithstanding this statement, *.txt
>>files can be opened from within Excel itself. However, it goes into a
>>parsing box to separate the text fields and text. This is simply the
>>generic programming for most spreadsheet programs...they are not (and
>>were not) designed to handle an entire *.txt file within a single cell.
>>Instead, spreadsheet applications can (and will) search for delimiters
>>that puts text into their proper columns, rows and cells.
>>


 
Reply With Quote
 
=?Utf-8?B?UmljayBIYW1pbHRvbg==?=
Guest
Posts: n/a
 
      28th Mar 2007
Bob,

I HAVE tried to associate TXT files with Excel, it's not working. Steps to
date:
1. Open Windows Explorer
2. Right click a .TXT file
3. Click "Open With"
4. Click "Choose Program"
5. Click Browse
6. Click to EXCEL.EXE path, which is C:\Program Files\Microsoft
Office\Office11\
7. Click on EXCEL.EXE
8. Click on checkbox to mark, Always Use The Selected Program...
9. Click OK.

The system continues to open the TXT file with Notepad. If I right-click
the file in Windows Explorer, then click "Open With", it does NOT, after
doing
the above, even SHOW Excel as an option.

I have tried the DOS command, ASSOC=.TXT= (space)
to delete the association of a TXT file to notepad, but that will not work.
Help! Thanks.

r.

"Bob I" wrote:

> Just R-click txt file and pick Open With, Choose Program, Browse, get
> Excel.exe and pop the Always use box. test it. Now go back to Open with
> and change the Always open with back to Notepad if you want, but the
> Excel will stay.
>
> Rick Hamilton wrote:
>
> > Dear G,
> >
> > I know exactly how Excel handles TXT files, I push tab-delimited text files
> > into Excel every day, and they parse perfectly, so this is NOT an Excel
> > question. It's a Windows question, because I cannot get EXCEL to be listed
> > in the list of programs which XP presents. when you right-click the file and
> > choose open with. It's an XP bug, IMHO. Suggestions?
> >
> > r.
> >
> > "Ghostrider" wrote:
> >
> >
> >>Rick Hamilton wrote:
> >>
> >>
> >>>EXCEL.EXE is already in the list. Name=b, Type=REG_SZ, DATA=EXCEL.EXE
> >>>
> >>>NOTEPAD.EXE is the first value. Any other suggestions? Thanks!
> >>>
> >>>Rick
> >>>
> >>>"JockoBailey" wrote:
> >>
> >>This question might have been better addressed and answered in a MS
> >>Office or Excel newsgroup instead of here. AFAIK, the default app for
> >>opening *.txt files is Notepad. Notwithstanding this statement, *.txt
> >>files can be opened from within Excel itself. However, it goes into a
> >>parsing box to separate the text fields and text. This is simply the
> >>generic programming for most spreadsheet programs...they are not (and
> >>were not) designed to handle an entire *.txt file within a single cell.
> >>Instead, spreadsheet applications can (and will) search for delimiters
> >>that puts text into their proper columns, rows and cells.
> >>

>
>

 
Reply With Quote
 
Ayush
Guest
Posts: n/a
 
      28th Mar 2007
Replied to [Rick Hamilton]s message :
> I have tried to associate TXT files with Excel, it's not working. Steps to
> date:



Control Panel > Folder Options
File types tab > Select .txt and click Advanced (or Restore first)
Select the default action and click Edit
Click Browse and select Excel.exe
Uncheck "Use DDE" > Click OK > OK > OK


if that doesn't work, then :

Click Start > Run > CMD > Run:
assoc .txt=txtfile

Then open regedit.exe
Navigate to: HKEY_CLASSES_ROOT\txtfile\shell\open
Right side, enter:
pathtoexcel.exe "%1"


z

 
Reply With Quote
 
Bob I
Guest
Posts: n/a
 
      29th Mar 2007
If Ayush's method doesn't work, I suggest doing Help, Detect and Repair
on Excel to repair the registry entries. Something is a bit wonky.

Rick Hamilton wrote:

> Bob,
>
> I HAVE tried to associate TXT files with Excel, it's not working. Steps to
> date:
> 1. Open Windows Explorer
> 2. Right click a .TXT file
> 3. Click "Open With"
> 4. Click "Choose Program"
> 5. Click Browse
> 6. Click to EXCEL.EXE path, which is C:\Program Files\Microsoft
> Office\Office11\
> 7. Click on EXCEL.EXE
> 8. Click on checkbox to mark, Always Use The Selected Program...
> 9. Click OK.
>
> The system continues to open the TXT file with Notepad. If I right-click
> the file in Windows Explorer, then click "Open With", it does NOT, after
> doing
> the above, even SHOW Excel as an option.
>
> I have tried the DOS command, ASSOC=.TXT= (space)
> to delete the association of a TXT file to notepad, but that will not work.
> Help! Thanks.
>
> r.
>
> "Bob I" wrote:
>
>
>>Just R-click txt file and pick Open With, Choose Program, Browse, get
>>Excel.exe and pop the Always use box. test it. Now go back to Open with
>>and change the Always open with back to Notepad if you want, but the
>>Excel will stay.
>>
>>Rick Hamilton wrote:
>>
>>
>>>Dear G,
>>>
>>>I know exactly how Excel handles TXT files, I push tab-delimited text files
>>>into Excel every day, and they parse perfectly, so this is NOT an Excel
>>>question. It's a Windows question, because I cannot get EXCEL to be listed
>>>in the list of programs which XP presents. when you right-click the file and
>>>choose open with. It's an XP bug, IMHO. Suggestions?
>>>
>>>r.
>>>
>>>"Ghostrider" wrote:
>>>
>>>
>>>
>>>>Rick Hamilton wrote:
>>>>
>>>>
>>>>
>>>>>EXCEL.EXE is already in the list. Name=b, Type=REG_SZ, DATA=EXCEL.EXE
>>>>>
>>>>>NOTEPAD.EXE is the first value. Any other suggestions? Thanks!
>>>>>
>>>>>Rick
>>>>>
>>>>>"JockoBailey" wrote:
>>>>
>>>>This question might have been better addressed and answered in a MS
>>>>Office or Excel newsgroup instead of here. AFAIK, the default app for
>>>>opening *.txt files is Notepad. Notwithstanding this statement, *.txt
>>>>files can be opened from within Excel itself. However, it goes into a
>>>>parsing box to separate the text fields and text. This is simply the
>>>>generic programming for most spreadsheet programs...they are not (and
>>>>were not) designed to handle an entire *.txt file within a single cell.
>>>>Instead, spreadsheet applications can (and will) search for delimiters
>>>>that puts text into their proper columns, rows and cells.
>>>>

>>
>>


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
file association not working Farhan Windows XP General 1 19th Nov 2008 01:35 AM
My .bat File Association is not Working =?Utf-8?B?cGVkd2FyZHM=?= Windows Vista General Discussion 0 23rd Feb 2007 07:42 PM
File Association for BMP not working when using ShellExecute brock.haywood@gmail.com Windows XP Embedded 1 28th Aug 2006 11:28 PM
Excel File Association not working =?Utf-8?B?U2FuZHkgTQ==?= Microsoft Excel Discussion 1 13th Feb 2006 04:10 PM
excel file association (double click) not working ! Nick Calladine Microsoft Excel Setup 3 6th Jun 2005 06:43 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:24 AM.