p2p.wrox.com Forums - Referencing an ActiveX DLL from Excel

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)

- Excel VBA (http://p2p.wrox.com/forumdisplay.php?f=79)

- - Referencing an ActiveX DLL from Excel (http://p2p.wrox.com/showthread.php?t=3716)

james gold

September 10th, 2003 10:14 AM

Referencing an ActiveX DLL from Excel

Hi,

I have written an ActiveX DLL with VB6, and now I want to reference it from an Excel 2002 spreadsheet, so that the procedures it contains can be called from the spreadsheet.

Please can you tell me how to reference it? I know that there is a way to get a window up, showing which DLLs are to be used in the workbook, but I can't find the menu option to get to this window.

Thanks.

James

james gold

September 10th, 2003 10:41 AM

Sorry, my mistake - this is trivial.

From the VB Editor, select Tools -> References.

All times are GMT -4. The time now is 05:14 AM.