Excel libraries in VB.NET

[Alan]

Does anyone know the difference between the Excel 5 library and Excel
11.0 Object Library?

I am using Visual Studio 2008 and cannot find a listing (under
COM libraries) for 11.0.

Thanks, Alan

 

[Peter T]

5 : Excel 5 (in 1993)
7 : Excel 95
8 : '97
9 : 2000
10 : 2002
11 : 2003
12 : 2007
14 : 2010

Office 1998 was for Mac, although there was Outlook 98 for PC

AFAIK VB.Net will not work with Excel 5

Regards,
Peter T

 

[Alan]

That`s sort of what I thought.. ...

Questions:

1. What is the easiest way to find the Excel 11.0 Object Library on my
hard disk, if it exists?

2. If it`s not there, do you know if I can find it someplace and
download it?

Thanks, Alan

 

[Alan]

I think the IDE or Office may be forcing use of the 2007 (12.0) object
library, and I think perhaps I need to modify the "binding redirect
policy," but I cannot find an authorirative reference on this.

Can anyone point me in the right direction?

Alan

 

[Peter T]

OK I understand your problem now. You will need to have Excel 2003
installed, if you have an MSDN subscription you can get it there, otherwise
I imagine it can be bought quite cheaply

You can develop in the 2007 machine, take your project to a system with 2003
and compile on that. Not ideal though. If you need to cater for both 2003 &
2007 you will find it easier to have both versions installed on your system.
Maybe you can install 2003 into a new VM. Otherwise you must install
versions in oldest first order. So uninstall 2007 before installing 2003,
then reinstall 2003. (tip - choose separate folders rather than the
default).

Regards,
Peter T

 

[Peter T]

typo

So uninstall 2007 before installing 2003, then reinstall 2003.

should read -

So uninstall 2007 before installing 2003, then reinstall 2007.

Peter T

 

[Alan]

Peter,

Could you please explain your statement: "Maybe you can install 2003
into a new VM"?

Thanks for the info. I was afraid of that.

I cannot afford an MSDN subscription, but I`ll look into buying Excel
2003.

Thanks, Alan

 

[Peter T]

VM = Virtual Machine

(eg MS Virtual PC 2007)

Regards,
Peter T

 

[Alan]

Based on http://www.microsoft.com/windows/virtual-pc/, MS Virtual PC
appears to be a feature of Windows 7. However, I have Vista.

Thanks, Alan

 

[Alan]

Peter,

Is "Office XP" the same as "Office 2002" (using 10.0 object library)?

Thanks, Alan

 

[Peter T]

I know, it's confusing, but see system requirements here

http://www.microsoft.com/downloads/...02-3199-48A3-AFA2-2DC0B40A73B6&displaylang=en


Regards,
Peter T

 

[Peter T]

Yes, Office XP = 2002 = v.10

Regards,
Peter T

 

[Alan]

Peter,

I found a PC with Excel 2003 installed. The Excel 11.0 Object Library
is listed under COM References in VB 2008 Express. However, when I
select it, it says it cannot find the file. I checked under Windows
\Assembly\... and found no assembly/dll for it there.

Do you think this might be fixed by downloading the .NET
redistributable framework, or is this more likely a problem with the
Excel installation?

Thanks, Alan

 

[Peter T]

Sounds like the Excel 11.0 Object Library is definitely there, well it must
be otherwise Excel 2003 wouldn't work. And assuming Excel does work the
problem is nothing to do with installing the .Net update.

Maybe the project is trying to find Excel.exe in the path where it existed
in the Excel 2007 machine.

Regards,
Peter T

 

[Alan]

No, this is a completely different PC, which has never had 2007 on it.

Any ideas on what I could try?

Thanks, Alan

 

[Peter T]

That wasn't what I meant.

Are you having problems to find Excel starting .Net as a brand new project,
or with the project originally made in the 2007 machine and copied to the
2003 machine.

If the former I don't know why you can't find the Excel library, if the
latter it's probably down to what I mentioned last time.

Regards,
Peter T

 

[Alan]

It was a new project.

 

[Peter T]

Can you browse to excel.exe to set the ref, apart from that I'm out of
ideas.

Regards,
Peter T