VB6 and Excel 97

I need to be able to access and manipulate an excel 97 spreadsheet (with multiple sheets) from my own VB6 application, like you can do with Access Db files. I mainly need to be able to call macros to perform various actions on the data in the spreadhseet.

Failing that, I want to be able to open excel and the file from my app, then return to my app when finished.

Can anyone help?

M.R.Chambers