Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding a DLL to Excel (2003) Object Browser
How do I add a reference to a new DLL to my object brower to be able to use
in in VBA 2003? Mac in Berkeley, CA |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding a DLL to Excel (2003) Object Browser
You need to declare the library outside a sub routine like this
' Declare wininet.dll API Functions Public Declare Function FtpSetCurrentDirectory Lib "wininet.dll" Alias "FtpSetCurrentDirectoryA" _ (ByVal hFtpSession As Long, ByVal lpszDirectory As String) As Boolean Public Declare Function FtpGetCurrentDirectory Lib "wininet.dll" Alias "FtpGetCurrentDirectoryA" _ (ByVal hFtpSession As Long, ByVal lpszCurrentDirectory As String, lpdwCurrentDirectory As Long) As Boolean Sub Mysub() your code exit sub "Mac Lingo" wrote: How do I add a reference to a new DLL to my object brower to be able to use in in VBA 2003? Mac in Berkeley, CA |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding a DLL to Excel (2003) Object Browser
It depends on what type of dll you mean. Try Tools / References, scroll down
and tick the "description" of the dll. Note this is not normally the file name. If not in the list use "browse" to file. If it doesn't 'take' either it's not registered on your system or it's not a dll that requires a reference nor one you'll see in Object Browser, refer to Joel's example. Regards, Peter T "Mac Lingo" wrote in message ... How do I add a reference to a new DLL to my object brower to be able to use in in VBA 2003? Mac in Berkeley, CA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do web query excel 2003 from site in browser? | Excel Discussion (Misc queries) | |||
Object Browser does what? | Excel Programming | |||
Object Browser Help | Excel Programming | |||
Object Browser Help | Excel Programming | |||
excel 2003 browser control?? | Excel Programming |