Problems with Associating extensions in Office 2010

networkn
networkn used Ask the Experts™
on
Hi There!

We have a client with a bunch of XLR and WPS Documents. I want to know how I can associate xlr so that you can open it by double clicking? I have tried everything I normally would but it doesn't seem to work! I can open from the file menu of Excel no problems. When I try and use the normal methods, it won't let me locate excel.exe (No where to be found, but running excel works fine). I even tried associating with the same thing as the shortcut for excel was which is something like "C:\Program Files (x86)\Common Files\microsoft shared\Virtualization Handler\CVH.EXE" "Microsoft Excel 2010" but I can only select CVH.exe and I can't see how to parse the parameter "excel 2010" to it?

The client runs Windows 7 and Office 2010.

There must be an easy way of doing this.

Also is there a batch conversion utility for WPS to .DOC that is reliable?

Any assistance appreciated.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
open a cmd prompt
type assoc .xlr excel.exe

Author

Commented:
I get :
File association not found for extension .xlr

Commented:
type assoc  by itself to see all file associations

TYpe assoc .fileExtension Program.exe   to set a file extension association

ASsoc .txt notepad.exe

type assoc .xlr excel.exe

Play with it, or google it to find out further info on how to use the assoc command.     You might even be able to type help, or help assoc at the cmd prompt.

Commented:
You need to add 1% or %1 at the end, look at how PDF is set to Adobe Reader and do the same.
Commented:
Actually the command was this:

assoc .xlr=Excel.Sheet.8

Had to do this from an elevated command prompt.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial