I'm trying to fix a problem in my add-in that only occurs when the
user starts Excel by double-clicking a workbook file. But the problem
is slightly different depending on the version of Excel.

Is there a quick way to change what version starts up when you double-
click a workbook? Having to reinstall Excel each time I want to change
takes a lot of time when I'm changing often.

I suspect you have Excel 2003 and 2007 on your machine. I think there is a
setting to define which version starts up automatically (and I saw it set
recently, but don't remember where to find it). It was buried. Why not
open the version you need first and then double click on the workbook you
want opened.

"Greg Lovern" wrote:

> I'm trying to fix a problem in my add-in that only occurs when the
> user starts Excel by double-clicking a workbook file. But the problem
> is slightly different depending on the version of Excel.
>
> Is there a quick way to change what version starts up when you double-
> click a workbook? Having to reinstall Excel each time I want to change
> takes a lot of time when I'm changing often.
>

Hi Barb,

The reason I don't just open the version I need first and then double-
click on the workbook I want opened is because the error does not
occur that way. My users are getting the error by double-clicking the
workbook file before Excel is opened. The error occurs when the add-in
is doing it's initialization tasks. If Excel is opened first, then
those initialization tasks are completed by the time you double-click
on the workbook file, therefore no error.

Yes, I have excel 2007 and 2003 installed. Also 2002, 2000, and 97. I
have to test in all of them, and when a user reports a problem, I need
to be able to test in the version they are using. Usually it doesn't
matter which version starts if Excel is started by double-clicking a
workbook file, but for this particular problem, it does matter.

Can anyone point me to the setting Barb mentioned ("a setting to
define which version starts up automatically")?


Thanks,

Greg

On May 15, 5:28*pm, Barb Reinhardt
<BarbReinha...@discussions.microsoft.com> wrote:
> I suspect you have Excel 2003 and 2007 on your machine. * I think thereis a
> setting to define which version starts up automatically (and I saw it set
> recently, but don't remember where to find it). * It was buried. * Why not
> open the version you need first and then double click on the workbook you
> want opened. *
>
>
>
> "Greg Lovern" wrote:
> > I'm trying to fix a problem in my add-in that only occurs when the
> > user starts Excel by double-clicking a workbook file. But the problem
> > is slightly different depending on the version of Excel.
>
> > Is there a quick way to change what version starts up when you double-
> > click a workbook? Having to reinstall Excel each time I want to change
> > takes a lot of time when I'm changing often.- Hide quoted text -
>
> - Show quoted text -

You can set the default by running the desired version of Excel from
the Run dialog, using the /regserver switch. Close all versions of
Excel, go to the Windows Start menu, choose Run and enter the
following and click OK.

"C:\Program Files\Microsoft Office 2003\Office11\Excel.exe" /regserver

Change the directory path to the folder in which the desired version
of Excel resides.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)




On Fri, 15 May 2009 14:54:35 -0700 (PDT), Greg Lovern
<(E-Mail Removed)> wrote:

>I'm trying to fix a problem in my add-in that only occurs when the
>user starts Excel by double-clicking a workbook file. But the problem
>is slightly different depending on the version of Excel.
>
>Is there a quick way to change what version starts up when you double-
>click a workbook? Having to reinstall Excel each time I want to change
>takes a lot of time when I'm changing often.

Thanks! :-)

That works great for 2002 and later.

On 2000 it requires the setup CD. That's probably still better than
running setup, but I didn't follow through because I'll need to go dig
out the disk.

It doesn't work at all on 97.


Greg


On May 16, 6:42*am, Chip Pearson <c...@cpearson.com> wrote:
> You can set the default by running the desired version of Excel from
> the Run dialog, using the /regserver switch. Close all versions of
> Excel, go to the Windows Start menu, choose Run and enter the
> following and click OK.
>
> "C:\Program Files\Microsoft Office 2003\Office11\Excel.exe" /regserver
>
> Change the directory path to the folder in which the desired version
> of Excel resides.
>
> Cordially,
> Chip Pearson
> Microsoft Most Valuable Professional
> * * Excel Product Group, 1998 - 2009
> Pearson Software Consulting, LLCwww.cpearson.com
> (email on web site)
>
> On Fri, 15 May 2009 14:54:35 -0700 (PDT), Greg Lovern
>
>
>
> <gr...@gregl.net> wrote:
> >I'm trying to fix a problem in my add-in that only occurs when the
> >user starts Excel by double-clicking a workbook file. But the problem
> >is slightly different depending on the version of Excel.
>
> >Is there a quick way to change what version starts up when you double-
> >click a workbook? Having to reinstall Excel each time I want to change
> >takes a lot of time when I'm changing often.- Hide quoted text -
>
> - Show quoted text -