Check out NPOI[^]. It takes a little getting used to but it works extremely well. Aparently it can't do pivot tables and has problems with working with Excel templates that contain macros, and I've yet to figure out how to insert images into the header/footer - but otherwise it does everything and it's free! Tony (the dev) always responds quickly to any problems too!
Dave
Generic BackgroundWorker - My latest article!
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Why are you using VB6? Do you hate yourself? (Christian Graus)