Access current active workbook from DLL

  • Thread starter Thread starter hon123456
  • Start date Start date
H

hon123456

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
 
There are various objects you can work with :
ActiveWorkbook
ActiveSheet
ActiveCell

Depending how the DLL and Excel interact ;
- Excel passes criteria & Recordset object to DLL > DLL queries DB and
receives data >DLL passes back filled RS > Excel fills range
The DLL does need to know anything about Excel; Excel and DLL need ADO.
- Excel passes criteria & start Range to DLL > DLL queries DB and receives
data > DLL fills data starting at passed range
DLL needs to know about Excel & ADO.

NickHK
 
Back
Top