Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Access current active workbook from DLL
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Access current active workbook from DLL
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 "hon123456" wrote in message ups.com... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Populate current active cell - Help Please!! | Excel Worksheet Functions | |||
Inesert value of column B of the current row into active cell | Excel Programming | |||
How to indicate that the current visible worksheet is the active o | Excel Programming | |||
Identify current active cell | Excel Worksheet Functions | |||
How to detect current active sheet number | Excel Programming |