VB Express & Excel automation ?

[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
--

 

[Mike McIntyre]

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

 

[Paul Clement]

¤ 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)

 

[Gultekin Komanli]

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
--