Excel Automation

[Greg Chang]

I had a VB 6 program that use COM interface to automate
Excel.

What is the best way to work similar thing in .Net VB?
still using COM interface? or there are a better way
(managed codes)?

Please help thanks.

Greg

[William Ryan]

You need to add a reference to system.runtime.INteropservices and it works
essentially the same way. Add a reference to the corresponding Excel .dll
as well.
"Greg Chang" <an*******@discussions.microsoft.com> wrote in message
news:19****************************@phx.gbl...

I had a VB 6 program that use COM interface to automate
Excel.

What is the best way to work similar thing in .Net VB?
still using COM interface? or there are a better way
(managed codes)?

Please help thanks.

Greg

[William Ryan]

You need to add a reference to system.runtime.INteropservices and it works
essentially the same way. Add a reference to the corresponding Excel .dll
as well.
"Greg Chang" <an*******@discussions.microsoft.com> wrote in message
news:19****************************@phx.gbl...

I had a VB 6 program that use COM interface to automate
Excel.

What is the best way to work similar thing in .Net VB?
still using COM interface? or there are a better way
(managed codes)?

Please help thanks.

Greg

[Greg Chang]

I don't have "system.runtime.INteropservices" in the list
of the .Net Tab of my "Add Reference" windows.
How do I get it there?

-----Original Message-----
You need to add a reference to system.runtime.INteropservices and it worksessentially the same way. Add a reference to the corresponding Excel .dllas well.
"Greg Chang" <an*******@discussions.microsoft.com> wrote in messagenews:19****************************@phx.gbl...

I had a VB 6 program that use COM interface to automate
Excel.

What is the best way to work similar thing in .Net VB?
still using COM interface? or there are a better way
(managed codes)?

Please help thanks.

Greg

.

[Greg Chang]

I don't have "system.runtime.INteropservices" in the list
of the .Net Tab of my "Add Reference" windows.
How do I get it there?

-----Original Message-----
You need to add a reference to system.runtime.INteropservices and it worksessentially the same way. Add a reference to the corresponding Excel .dllas well.
"Greg Chang" <an*******@discussions.microsoft.com> wrote in messagenews:19****************************@phx.gbl...

I had a VB 6 program that use COM interface to automate
Excel.

What is the best way to work similar thing in .Net VB?
still using COM interface? or there are a better way
(managed codes)?

Please help thanks.

Greg

.

[William Ryan]

It should already be included, try just typing it at the top. You'll need
to add a reference to the Excel automation library and you have different
choices 9.0 for instance, depening on which one you want to use.

HTH,

Bill
"Greg Chang" <an*******@discussions.microsoft.com> wrote in message
news:03****************************@phx.gbl...

I don't have "system.runtime.INteropservices" in the list
of the .Net Tab of my "Add Reference" windows.
How do I get it there?

-----Original Message-----
You need to add a reference to

system.runtime.INteropservices and it works

essentially the same way. Add a reference to the

corresponding Excel .dll

as well.
"Greg Chang" <an*******@discussions.microsoft.com> wrote

in message

news:19****************************@phx.gbl...

I had a VB 6 program that use COM interface to automate
Excel.

What is the best way to work similar thing in .Net VB?
still using COM interface? or there are a better way
(managed codes)?

Please help thanks.

Greg

.

[William Ryan]

It should already be included, try just typing it at the top. You'll need
to add a reference to the Excel automation library and you have different
choices 9.0 for instance, depening on which one you want to use.

HTH,

Bill
"Greg Chang" <an*******@discussions.microsoft.com> wrote in message
news:03****************************@phx.gbl...

I don't have "system.runtime.INteropservices" in the list
of the .Net Tab of my "Add Reference" windows.
How do I get it there?

-----Original Message-----
You need to add a reference to

system.runtime.INteropservices and it works

essentially the same way. Add a reference to the

corresponding Excel .dll

as well.
"Greg Chang" <an*******@discussions.microsoft.com> wrote

in message

news:19****************************@phx.gbl...

I had a VB 6 program that use COM interface to automate
Excel.

What is the best way to work similar thing in .Net VB?
still using COM interface? or there are a better way
(managed codes)?

Please help thanks.

Greg

.

[Rob Oldfield]

I'd say you're better off going for the ADO approach. See...

http://support.microsoft.com/default...d=kb;ko;257819

The 'traditional' method has problems e.g.
http://support.microsoft.com/default...b;en-us;317109 which doesn't
work correctly, and the fact that including the additional libraries bloats
the size needed (the msi for a project of mine went from something like 300K
up to 4 meg.

If, by the way, you do continue down the automation route and run into the
problem in 317109 then mail me as I've just figured it out.

--
For real reply address, lose the cash
www.realuk.co.uk

"Greg Chang" <an*******@discussions.microsoft.com> wrote in message
news:19****************************@phx.gbl...

I had a VB 6 program that use COM interface to automate
Excel.

What is the best way to work similar thing in .Net VB?
still using COM interface? or there are a better way
(managed codes)?

Please help thanks.

Greg

[Rob Oldfield]

I'd say you're better off going for the ADO approach. See...

http://support.microsoft.com/default...d=kb;ko;257819

The 'traditional' method has problems e.g.
http://support.microsoft.com/default...b;en-us;317109 which doesn't
work correctly, and the fact that including the additional libraries bloats
the size needed (the msi for a project of mine went from something like 300K
up to 4 meg.

If, by the way, you do continue down the automation route and run into the
problem in 317109 then mail me as I've just figured it out.

--
For real reply address, lose the cash
www.realuk.co.uk

"Greg Chang" <an*******@discussions.microsoft.com> wrote in message
news:19****************************@phx.gbl...

I had a VB 6 program that use COM interface to automate
Excel.

What is the best way to work similar thing in .Net VB?
still using COM interface? or there are a better way
(managed codes)?

Please help thanks.

Greg

[William Ryan]

As someone who's done a lot of Excel Automation in .NET, I have to agree
with Rod. There is a lot of bloat and it can be really slow. However,
sometimes you have to dive into the Excel Library, but I'd avoid it as much
as possible.
"Rob Oldfield" <r$ob@oldfi$eld100.freese$rve.c$o.uk> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl...

I'd say you're better off going for the ADO approach. See...

http://support.microsoft.com/default...d=kb;ko;257819

The 'traditional' method has problems e.g.
http://support.microsoft.com/default...b;en-us;317109 which doesn't work correctly, and the fact that including the additional libraries bloats the size needed (the msi for a project of mine went from something like 300K up to 4 meg.

If, by the way, you do continue down the automation route and run into the
problem in 317109 then mail me as I've just figured it out.

--
For real reply address, lose the cash
www.realuk.co.uk

"Greg Chang" <an*******@discussions.microsoft.com> wrote in message
news:19****************************@phx.gbl...

I had a VB 6 program that use COM interface to automate
Excel.

What is the best way to work similar thing in .Net VB?
still using COM interface? or there are a better way
(managed codes)?

Please help thanks.

Greg

[William Ryan]

As someone who's done a lot of Excel Automation in .NET, I have to agree
with Rod. There is a lot of bloat and it can be really slow. However,
sometimes you have to dive into the Excel Library, but I'd avoid it as much
as possible.
"Rob Oldfield" <r$ob@oldfi$eld100.freese$rve.c$o.uk> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl...

I'd say you're better off going for the ADO approach. See...

http://support.microsoft.com/default...d=kb;ko;257819

The 'traditional' method has problems e.g.
http://support.microsoft.com/default...b;en-us;317109 which doesn't work correctly, and the fact that including the additional libraries bloats the size needed (the msi for a project of mine went from something like 300K up to 4 meg.

If, by the way, you do continue down the automation route and run into the
problem in 317109 then mail me as I've just figured it out.

--
For real reply address, lose the cash
www.realuk.co.uk

"Greg Chang" <an*******@discussions.microsoft.com> wrote in message
news:19****************************@phx.gbl...

I had a VB 6 program that use COM interface to automate
Excel.

What is the best way to work similar thing in .Net VB?
still using COM interface? or there are a better way
(managed codes)?

Please help thanks.

Greg

[William Ryan]

http://msdn.microsoft.com/vstudio/of...l/excelobj.asp
"Greg Chang" <an*******@discussions.microsoft.com> wrote in message
news:19****************************@phx.gbl...

I had a VB 6 program that use COM interface to automate
Excel.

What is the best way to work similar thing in .Net VB?
still using COM interface? or there are a better way
(managed codes)?

Please help thanks.

Greg

[William Ryan]

http://msdn.microsoft.com/vstudio/of...l/excelobj.asp
"Greg Chang" <an*******@discussions.microsoft.com> wrote in message
news:19****************************@phx.gbl...

I had a VB 6 program that use COM interface to automate
Excel.

What is the best way to work similar thing in .Net VB?
still using COM interface? or there are a better way
(managed codes)?

Please help thanks.

Greg