By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,734 Members | 828 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,734 IT Pros & Developers. It's quick & easy.

VB Express & Excel automation ?

P: n/a
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
--

Aug 29 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
You will need to add a COM reference to the Microsoft Object Library.
--
Mike

Mike McIntyre [MVP]
http://www.getdotnetcode.com
"Gultekin Komanli" <gk******@gmail.comwrote in message
news:uZ**************@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
--

Aug 30 '06 #2

P: n/a
On Tue, 29 Aug 2006 02:14:24 -0700, "Gultekin Komanli" <gk******@gmail.comwrote:

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)
Aug 30 '06 #3

P: n/a
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
--

Aug 31 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.