Referencing a spreadsheet from an ActiveX DLL
I am writing an ActiveX DLL with VB6, which is referenced by my Excel spreadsheet. i.e. my DLL has functions which I call from the VBA in the spreadsheet.
I am passing cell data from the spreadsheet as parameters when I call the DLL functions from the VBA. The DLL then manipulates that data and sends back the results to the spreadsheet VBA. The VBA then plugs the results into the appropriate cells.
This is the first time I have done this, and have a related question.
Instead of passing the cell data to the DLL functions, is there a way that a DLL function can "look at" the spreadsheet and get the cell data for itself? This would involve (I guess) the DLL function being able to reference the spreadsheet (workbook) in some way.
Is this possible? If so, how do I do it?
Hope you can help - all info is useful as I am new to this.