simple program using jacob and excel

Question

i want to learn jacob for doing tasks with excel. looking for any simple code using jacob and excel which runs without errors. i tried running the code in jacob help but i'm getting errors. to understand the basics i need a simple code. Can you provide me this sample code .thanks

Answer 1

Would help if you posted the errors and what exactly you are trying to do.

Is there any reason you would not use Apache POI http://poi.apache.org/

In either case I found it was helpful to do the work in VB first and then make the calls with JACOB because you can them map across easily