Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to change what version of Excel starts when double-click aworkbook
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to change what version of Excel starts when double-click a wor
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to change what version of Excel starts when double-click awor
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 wrote: 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.- Hide quoted text - - Show quoted text - |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to change what version of Excel starts when double-click a workbook
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 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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to change what version of Excel starts when double-click aworkbook
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 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 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 - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to use selection change instead of double click event? | Excel Discussion (Misc queries) | |||
How to change syperlink from single click to double click | Excel Worksheet Functions | |||
on double click change cell color | Excel Programming | |||
Double-Click to Change Interoir Color | Excel Programming | |||
Change single click to double click | Excel Programming |