Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
De-activating Excel 12, Leaving 11 Active?
I need to test some stuff that is written for Excel 11, and
chokes on 12 (YIELD function). I have both 11 and 12 installed on my developer box and, of course, when the problem app instantiates "Excel.Application" it winds up with 12 - even when CreateObject's argument is changed to from "Excel.Application" to "Excel.Application.11" BCO Office 12's security/copy protection scheme, it's a big deal to get Office 12 installed on a PC in my environment or I'd just uninstall 11, do my testing, and then re-install 12. The Question: Is there a way to make 12 invisible to the system so it acts as if 11 is the only version installed, do my testing, and then revert to 11 and 12? -- PeteCresswell |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
De-activating Excel 12, Leaving 11 Active?
Have you tried the unregserver and regserver method to re-register
your choice of default Excel version? Do a google search on regserver under Dibben as author. Gord On Sun, 06 Nov 2011 17:41:39 -0500, "(PeteCresswell)" wrote: I need to test some stuff that is written for Excel 11, and chokes on 12 (YIELD function). I have both 11 and 12 installed on my developer box and, of course, when the problem app instantiates "Excel.Application" it winds up with 12 - even when CreateObject's argument is changed to from "Excel.Application" to "Excel.Application.11" BCO Office 12's security/copy protection scheme, it's a big deal to get Office 12 installed on a PC in my environment or I'd just uninstall 11, do my testing, and then re-install 12. The Question: Is there a way to make 12 invisible to the system so it acts as if 11 is the only version installed, do my testing, and then revert to 11 and 12? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
De-activating Excel 12, Leaving 11 Active?
After serious thinking (PeteCresswell) wrote :
I need to test some stuff that is written for Excel 11, and chokes on 12 (YIELD function). I have both 11 and 12 installed on my developer box and, of course, when the problem app instantiates "Excel.Application" it winds up with 12 - even when CreateObject's argument is changed to from "Excel.Application" to "Excel.Application.11" BCO Office 12's security/copy protection scheme, it's a big deal to get Office 12 installed on a PC in my environment or I'd just uninstall 11, do my testing, and then re-install 12. The Question: Is there a way to make 12 invisible to the system so it acts as if 11 is the only version installed, do my testing, and then revert to 11 and 12? <FWIW Unfortunately, v12 will be reinstantiated as the default version whenever AutomaticUpdate installs updates. I hate when that happens! What I do instead (on my dev box) is open whichever version I want to use and open the project from within. I currently have versions 9 through 12 installed on this machine and I have no problem with 'default version' using Gord's suggestion via a '.bat' file. This is very helpful for testing projects that use their own instance of Excel via a VB6.EXE frontloader. What I found, though, is that v11 is the only early version it (unreg/reg) seems to work with. IOW, with v12 installed I can't 'set' v9 or v10 to be the default when v11 is installed. I'm sure it's doable but I don't care to spend the time to figure out how since I can open any version from the Office Toolbar. Also, you can run multiple versions simulataneously but you'll get the warning about PERSONAL.xls being Read Only for each subsequent version you open after the initial version. -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
De-activating Excel 12, Leaving 11 Active?
On 06/11/2011 22:41, (PeteCresswell) wrote:
I need to test some stuff that is written for Excel 11, and chokes on 12 (YIELD function). I have both 11 and 12 installed on my developer box and, of course, when the problem app instantiates "Excel.Application" it winds up with 12 - even when CreateObject's argument is changed to from "Excel.Application" to "Excel.Application.11" BCO Office 12's security/copy protection scheme, it's a big deal to get Office 12 installed on a PC in my environment or I'd just uninstall 11, do my testing, and then re-install 12. The Question: Is there a way to make 12 invisible to the system so it acts as if 11 is the only version installed, do my testing, and then revert to 11 and 12? Create a virtual machine with only v11 installed on it for testing. -- Regards, Martin Brown |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
De-activating Excel 12, Leaving 11 Active?
Thanks for the FYI. That will save me some head scratching next time there is an update. For now, my fix is to have executed Excel 11 on a command line with the /regserver parm added. viz "C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE" /regserver Dunno how it works, but now: - Instantiating Excel returns 11 - I can still run 12 using Windows' Start menu - Ditto 11 Only weak point - besides your observation - is that it doesn't seem to work the other way. But instantiating 11 is all I need for now, so I'm good to go..... as long as I remember to do it again after the next update -) Thanks again. Per GS: After serious thinking (PeteCresswell) wrote : I need to test some stuff that is written for Excel 11, and chokes on 12 (YIELD function). I have both 11 and 12 installed on my developer box and, of course, when the problem app instantiates "Excel.Application" it winds up with 12 - even when CreateObject's argument is changed to from "Excel.Application" to "Excel.Application.11" BCO Office 12's security/copy protection scheme, it's a big deal to get Office 12 installed on a PC in my environment or I'd just uninstall 11, do my testing, and then re-install 12. The Question: Is there a way to make 12 invisible to the system so it acts as if 11 is the only version installed, do my testing, and then revert to 11 and 12? <FWIW Unfortunately, v12 will be reinstantiated as the default version whenever AutomaticUpdate installs updates. I hate when that happens! What I do instead (on my dev box) is open whichever version I want to use and open the project from within. I currently have versions 9 through 12 installed on this machine and I have no problem with 'default version' using Gord's suggestion via a '.bat' file. This is very helpful for testing projects that use their own instance of Excel via a VB6.EXE frontloader. What I found, though, is that v11 is the only early version it (unreg/reg) seems to work with. IOW, with v12 installed I can't 'set' v9 or v10 to be the default when v11 is installed. I'm sure it's doable but I don't care to spend the time to figure out how since I can open any version from the Office Toolbar. Also, you can run multiple versions simulataneously but you'll get the warning about PERSONAL.xls being Read Only for each subsequent version you open after the initial version. -- PeteCresswell |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
De-activating Excel 12, Leaving 11 Active?
Pete,
Some updates do not effect this. I've had v11 as default for some months now and I definitely have had v12 updates that seem to not have had any effect on which version is currently set.<g -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I delete redundant records in Excel without then leaving b | Excel Discussion (Misc queries) | |||
Excel 2003-skip to another cell upon leaving | Excel Discussion (Misc queries) | |||
Activating macro by leaving a spreadsheet | Excel Programming | |||
Activating the last active worksheet | Excel Programming | |||
Excel.Application.Quit leaving Excel process stays active | Excel Programming |