How can I correct file type associations for ms excel?

I'm having problems with hyperlinks in excel.  I have a .ff extension that is a tiff file.  I've associated the extension with msPaint in windows, and it opens in paint when I double click it.  But when using a hyperlink in excel, I just get a popup saying that no program is registered to open this file.

i've researched and found that the link below resolved this issue for many, but when I run that command against mspaint.exe (or any program for that matter) all I get is a strange message. For mspaint it said: "c:\unregserver.bmp not found"

http://support.microsoft.com/kb/298019

any ideas?
jb09376Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

marsiliesCommented:
That link you found is only for associating Office programs (winword.exe, excel.exe, etc.) with their file formats. That command switch isn't likely to work with other programs, as you've found out.

You can force Office programs to use the file associations that Windows uses with the following registry edit:

First, create a System Restore point, then Start, Run regedit. Go to HKEY_LOCAL_MACHINE\Software\Microsoft\Office\9.0\Common\Internet and create a new DWORD value named ForceShellExecute. Double-click on this and give it a value of one, then close the Registry editor.


http://windowsxp.mvps.org/forceshellexecute.htm
http://support.microsoft.com/kb/218153
http://www.excelforum.com/excel-general/691045-hyperlinks-in-excel-open-picture-in-internet-explorer.html
http://www.petroons.net/?p=58
0
jb09376Author Commented:
I don't have that registry entry.  it goes ..\microsoft\office\12.0\...

then no common or internet folders.
0
jb09376Author Commented:
i did find HKEY_CURRENT_USER/programs/microsoft/office/12.0/common

and entered that entry, but still no luck
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

marsiliesCommented:
You may have to create the key path, possibly several levels of it.

So, from HKEY_LOCAL_MACHINE\Software\Microsoft\Office , create a new key "9.0" , then from that key create the key "Common", then from that key create the key 'Internet". Then from there create the DWORD "ForceShellExecute" and set it to 1.

http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_24766210.html
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jb09376Author Commented:
Tried that out and Excel still won't open the file.
0
marsiliesCommented:
You may have to reboot before it works.

I assume you have Office 2007, but what version of Windows do you have?
0
jb09376Author Commented:
This needs to work on any pc >xp

but the machine I'm testing on is vista home premium
0
jb09376Author Commented:
i mean it should work on any pc >= xp
0
marsiliesCommented:
So, did rebooting the PC work?
0
jb09376Author Commented:
nope.  still no luck.
0
marsiliesCommented:
Another possibility may be placing the value here:
HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Common\Internet

http://www.consumingexperience.com/2008/02/make-links-in-word-excel-etc-open-in.html#7669023991064179764
0
jb09376Author Commented:
I was ahead of you on that one.  Tried it and still nothing :-(

Any reason this is supposed to be placed under the internet key?  It doesn't seem to have anything to do with the internet.
0
marsiliesCommented:
It's probably placed under "Internet"  because it deals with hyperlinks.

Is your Vista 64-bit or 32-bit?

Also, have you tried just renaming the files to .tif or .tiff ? Is there any particular reason why they're named with an off-standard extension?
0
jb09376Author Commented:
it is 64 bit.  The whole system I'm working with revolves around these other extensions, but even with a .tiff or .tif extension, excel won't open the file.  .jpg works though.
0
jb09376Author Commented:
After trying it again, i believe your fix worked as long as the file is named *.tif.  That doesn't really work for my situation, but I found a workaround anyway.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.