Hi,

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.

Many thanks.

James

//##

check out http://www.greggriffiths.org/webdev/both/excel/ which covers VBScript ASP -> Excel connections and may provide some useful info and links for you.

You could potentially use the findwindow / findwindowex api calls to lookup an open excel instance but the way you're doing this is the best way by far & much less prone to errors occurring.