"Bob Phillips" wrote:
I have 2007 and 2003 on the same machine
(as well as 2000), no problem.
Thanks. Very helpful information.
I do find it very difficult to know which version
a spreadsheet will open in
Can you elaborate? Surely it is not random. (Famous last words.)
In Win XP, I believe there is a way to associate specific applications with
specific extensions. (Folder Options control File Types.) Can't you
assign Excel 2003 to "xls" and "csv" (and perhaps others) and Excel 2007 to
"xlsm"?
Not sure if browers pay attention to those File Types assignments, though.
The architecture has never been clear to me, e.g. how Excel appears to be in
an IE window instead of its own.
----- original message -----
"Bob Phillips" wrote in message
...
I have 2007 and 2003 on the same machine (as well as 2000), no problem.
Just make sure that you install it in a separate directory, and don't opt
for the upgrade option.
It has its own registry keys, so no problem there. I do find it very
difficult to know which version a spreadsheet will open in, it is never as
simple as .xls in 2p003, .xlsm in 2007 (I do have the compatibility pack
installed). I don't use IE6, I use Firefox, but it is the same with files
I download, I never know which version.
VBA will exist in each version, and can be accessed with Alt-F11, so you
can have separate VBIDEs open. VBA is exactly the same in 2007, but the
Excel object model has changed, so not everything works as it did.
--
__________________________________
HTH
Bob
"JoeU2004" wrote in message
...
I have Office/Excel 2003 on Win XP SP3.
I would like to install (just) Excel 2007 (not Office 2007) on the same
computer (standalone laptop).
I have found a 2008 posting with a reference to an MS KB that suggests
this is possible as long as 2007 products are installed after 2003
products, which would obviously be the case for me.
But that is not always the complete story.
Also, I am not an expert with Win XP and Office installations. I only
get them pre-installed on new computers that I purchase. So I want to be
sure that if I can install just Excel 2007 on the same computer with
Office/Excel 2003, it is virtually turn-key and idiot-proof.
Can anyone share their personal experiences with doing what I want to do?
Any gotchas that I need to be aware of?
(Besides being sure that I don't use the default path when installing
Excel 2007.)
Do Excel 2003 and 2007 share Registry keys?
Will IE6 continue to use Excel 2003, for example when I download CSV data
from an online bank account?
Will Win XP continue to use Excel 2003 when I click on a ".csv" and
".xls" file?
Will installing Excel 2007 after 2003 impact the VBA that I access when I
press alt+F11 in Excel 2003?
Will some VBA (same or different) be available when I press alt+F11 in
Excel 2007 if I install only Excel 2007?
(I don't know if VBA is integrated with Excel code, or if it is installed
separately. I know that there is a separate VB product. I don't think
I'm asking about that.)
Will I be able to uninstall Excel 2007 without affecting Office/Excel
2003? Are there any gotchas to be aware of?
(Please answer the last paragraph only if you have personal experience
doing so.)
I can deal with issues involving sharing files between Excel 2007 and
Office 2003 products. That is not a problem for me. I will probably use
Excel 2007 just for isolated experiments.
I am only concerned about system-wide issues that might arise -- things
that might break or work differently after installing (just) Excel 2007.
TIA.