Dear all,
I will write a DLL by using Visual Basic. Then I will call
the DLL in Excel VBA. Some variables will be passed to the DLL from
VBA. After that, the DLL will get recordset from database will fill the

cells in current active workbook. My question is how can I access the
current active workbook from the DLL? As I know, there is Microsoft
Excel 8.0 Object Library for VB? If this library is used to access
the current active workbook,what is the code to access current active
workbook and sheet?

Thanks