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