excel file question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I save many of my excel files as the name of the file and follow it with the initials of the company is relates to. for example, the 2004 budget for northeast hotel partners is saved as budget04.nhp. Some of my files for whatever reason do not show up as excel files. While in windows explorer, I right clicked on the file and selected the properties option. It came up with a "general tab". It says "Type of file": NHP file. Then it says Opens with: Microsoft excel --after I selected mirosoft excel. Then I selected apply. Now, all the files in the NHP folder no longer show the ".nhp" after the file name. This is a problem because I deal with multiple companies and I can have the budget04 file open for different companies and now I cannot tell them apart. Does anyone have any suggestions?
 
Personally I would never use a period in a filename, especially with only 3
letters after it, simply because it can get mistaken for an extension. Whats
wrong with an underscore and the initials, or even just a space. It sounds like
you have inadvertantly saved them as .nhp files instead of .xls. You may find
you have to go and rename them all to give them back the correct extensions. Do
you have Explorer set to hide the extensions of common filenames??

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
Newsgroups - Where you really can get a free lunch!!
----------------------------------------------------------------------------



tdora said:
I save many of my excel files as the name of the file and follow it with the
Click to expand...
initials of the company is relates to. for example, the 2004 budget for
northeast hotel partners is saved as budget04.nhp. Some of my files for whatever
reason do not show up as excel files. While in windows explorer, I right clicked
on the file and selected the properties option. It came up with a "general tab".
It says "Type of file": NHP file. Then it says Opens with: Microsoft
excel --after I selected mirosoft excel. Then I selected apply. Now, all the
files in the NHP folder no longer show the ".nhp" after the file name. This is a
problem because I deal with multiple companies and I can have the budget04 file
open for different companies and now I cannot tell them apart. Does anyone have
any suggestions?
 
Tdora,

If you must use extra periods in the filename, I think you'll have to type
the xls extension. If you type budget04.nhp, it won't get the xls
extension, and thus won't automatically be opened with Excel when
double-clicked in a file list (unless you set up an association in Windows
for nhp with Excel). You could type

budget04.nhp.xls

and I think it will work. If you must.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

tdora said:
I save many of my excel files as the name of the file and follow it with
Click to expand...
the initials of the company is relates to. for example, the 2004 budget for
northeast hotel partners is saved as budget04.nhp. Some of my files for
whatever reason do not show up as excel files. While in windows explorer, I
right clicked on the file and selected the properties option. It came up
with a "general tab". It says "Type of file": NHP file. Then it says Opens
with: Microsoft excel --after I selected mirosoft excel. Then I selected
apply. Now, all the files in the NHP folder no longer show the ".nhp" after
the file name. This is a problem because I deal with multiple companies and
I can have the budget04 file open for different companies and now I cannot
tell them apart. Does anyone have any suggestions?
 
If you put the filename in quotes when saving it, it will force excel to
save .nhp as part of the filename: eg

"budget04.nhp.xls"

Mark
 
Mark,

It seems to work the same with or without the quotes:

"budget04.nhp.xls"
budget04.nhp.xls

Either results in a file name of budget04.nhp.xls
 
Hi,

All the above suggestions will work and it is MUCH better that you do
not use the file extension ( the last 3 characters after the last
period) because eventually you will have a company with initials of
another type of of file (eg: *.doc). This would then get opened by
MS-Word if you have it.

One thing you should do is turn on the ability to view file extensions
of known files within Windows Explorer:
Tools - Folder Options - View (tab) - UNTICK "Hide file extensions of
known file types".

This will now show budget04.nhp in the explorer window rather just
budget04, or in the case of all files it will show filename.xxx where
xxx is the extension. This is much better than letting windows hide
information from you because "they" think it is easier for you not to
deal with it.

When you previously chose "Open with" Microsoft Excel, you set the
"file association" to Excel (even if you did not know) - so now double
clicking any file (whether created by Excel or not) with an extension
of *.nhp will cause windows to attempt to be open it with Excel.

Hope this helps you understand it a bit better.

Dug
 
Back
Top