I need/want to be able to control an Excel workbook from a VB6 app, like you can with an Access DB. I need to be able to input values to specific cells, activate macros (one of which imports data from Access and one that exports to Word)…all fromthe environment of my application. I have the Access part mostly sorted out, but was wondering about the Excel side.
Can anyone help?