Work with different Excel versions

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alessandro Cavalieri - 20 Jul 2004 15:05 GMT

Hi all,

I need to write a C# (but VB would be OK) class able to work with different
Excel versions at runtime (not compile conditional). Of course I would
prefer to use the type library because the code completation.

Someone knows some documentations or examples?

Thanks,
Alessandro

Reply to this Message

Howard Kaikow - 20 Jul 2004 15:29 GMT

I believe, VSO will work only with Office 2003.
You can use VB 6 to automate Excel for Excel 97, 2000, 2002 and 2003.
I would not use VB .NET because there are no official PIAs for Excel 97 and
Excel 2000.

Signature

http://www.standards.com/; See Howard Kaikow's web site.

> Hi all,
>
[quoted text clipped - 6 lines]
> Thanks,
> Alessandro

Reply to this Message

Alessandro Cavalieri - 22 Jul 2004 15:59 GMT

Thanks for the advice, I'll try to create an Excel97 PIA just to try.

> I believe, VSO will work only with Office 2003.
> You can use VB 6 to automate Excel for Excel 97, 2000, 2002 and 2003.
[quoted text clipped - 12 lines]
> > Thanks,
> > Alessandro

Reply to this Message

Peter Torr (MS) - 27 Jul 2004 04:59 GMT

> Thanks for the advice, I'll try to create an Excel97 PIA just to try.

You will find that many things will not work correctly; it's probably better
to go via reflection.

Peter

Signature

Peter Torr - http://weblogs.asp.net/ptorr/
This posting is provided "AS IS" with no warranties, and confers no rights
Samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

Reply to this Message

Work with different Excel versions

Free Magazines