Home All Groups Group Topic Archive Search About

VB Express & Excel automation ?

Author
29 Aug 2006 9:14 AM
Gultekin Komanli
Hi all,

I'm new to .NET stuff and trying find a way to do automation with
Excel, using VB 2005 EE.

I searched this forum, there are samples that use some namespaces for
office automation but I was not able to use those, is this feature
disabled or what is wrong ?

TIA
Gultekin
--

Author
30 Aug 2006 3:16 AM
Mike McIntyre
You will need to add a COM reference to the Microsoft Object Library.
--
Mike

Mike McIntyre [MVP]
http://www.getdotnetcode.com


Show quoteHide quote
"Gultekin Komanli" <gkoma***@gmail.com> wrote in message
news:uZthGu0yGHA.1304@TK2MSFTNGP05.phx.gbl...
> Hi all,
>
> I'm new to .NET stuff and trying find a way to do automation with
> Excel, using VB 2005 EE.
>
> I searched this forum, there are samples that use some namespaces for
> office automation but I was not able to use those, is this feature
> disabled or what is wrong ?
>
> TIA
> Gultekin
> --
>
Author
31 Aug 2006 2:01 PM
Gultekin Komanli
Mike McIntyre wrote:

> You will need to add a COM reference to the Microsoft Object Library.

Thanks Mike & Paul.

I tried to do this but after I add the reference of "Microsoft Excel
11.0 Object Library", I got "the system cannot find the reference
specified" on the path column.
This is strange, when trying to add it system shows that I got a COM
reference to Excel 2003 but then it says no !!

Can you say why this is happening ?

Gultekin
--
Author
30 Aug 2006 4:56 PM
Paul Clement
On Tue, 29 Aug 2006 02:14:24 -0700, "Gultekin Komanli" <gkoma***@gmail.com> wrote:

¤ Hi all,
¤
¤ I'm new to .NET stuff and trying find a way to do automation with
¤ Excel, using VB 2005 EE.
¤
¤ I searched this forum, there are samples that use some namespaces for
¤ office automation but I was not able to use those, is this feature
¤ disabled or what is wrong ?

See if the following helps:

http://support.microsoft.com/kb/301982/en-us
http://support.microsoft.com/kb/302094/en-us
http://support.microsoft.com/kb/822750/en-us
http://support.microsoft.com/kb/303871/en-us


Paul
~~~~
Microsoft MVP (Visual Basic)