Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 6th 11, 10:41 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2006
Posts: 139
Default 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   Report Post  
Old November 7th 11, 04:17 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2011
Posts: 621
Default 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   Report Post  
Old November 7th 11, 02:35 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2011
Posts: 3,514
Default 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   Report Post  
Old November 7th 11, 03:00 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2007
Posts: 230
Default 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   Report Post  
Old November 7th 11, 04:37 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2006
Posts: 139
Default 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   Report Post  
Old November 7th 11, 06:23 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2011
Posts: 3,514
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I delete redundant records in Excel without then leaving b GRE Excel Discussion (Misc queries) 1 January 9th 09 11:04 PM
Excel 2003-skip to another cell upon leaving Rich D Excel Discussion (Misc queries) 7 September 12th 08 10:15 PM
Activating macro by leaving a spreadsheet [email protected] Excel Programming 1 January 14th 07 02:58 AM
Activating the last active worksheet Chris M Excel Programming 2 June 28th 05 02:11 AM
Excel.Application.Quit leaving Excel process stays active Siggy Excel Programming 1 December 20th 04 09:26 AM


All times are GMT +1. The time now is 03:52 PM.

Powered by vBulletin® Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.
Copyright 2004-2022 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017