Excel automation

[Mark Goldin]

If I need to create a winforms application with OLE automation should I use
VB.NET or C#?
Are there good OFFICE automation examples for C#?

Thanks

 

[Guest]

I have created a C# application that controls Excel with OLE automation. It works fine, but my experience tells me that
- everything is not possible, you are limited to what is available in the documentatio
- everything that is documented does not always work, so you must test explicitly every function you call. The weakest point I've found is that you are never (or at best, poorly) advised of what happens inside Excel

Good luck
Alain