p2p.wrox.com Forums

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.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.