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
