Hi Marvin,
Just recently I found a book by O'Reilly called "Writing Excel Macros". It's more of an overview of the excel object heirarchy, and using the VBA IDE that excel offers, but it sounds like that's all you'd need anyways. I found it at a Waldenbooks on a mall, but some of my co-workers ordered it on-line after they saw I had it.

>Does anyone know any good resources on Excel Automation? Just simple stuff >like opening, modifing, and closing spreadsheets.