View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default How do DLLs Work?

These are generally referred to as the Windows 32 API. (application
programming interface)

You can start he

http://www.mentalis.org/

--
Regards,
Tom Ogilvy



"Colin Steadman" wrote in message
m...
I've just stumbled across this script in Google Groups-

================================================== ==============
Declare Function WNetGetConnection Lib "mpr.dll" _
Alias "WNetGetConnectionA" (ByVal lpszLocalName As String, _
ByVal lpszRemoteName As String, cbRemoteName As Long) As Long

'Shows where a drive is mapped to!

Sub ShowMappedDrivePath()
Dim Buffer As String * 255
Dim BuffSize As Long
BuffSize = 255
If WNetGetConnection("h:", Buffer, BuffSize) = 0 Then
MsgBox Left(Buffer, InStr(1, Buffer, Chr(0)) - 1)
End If
End Sub
================================================== ==============

And I have been using something similar to bring back username
(WNetGetUser) from mpr.dll (using another script I came across in
Google).

I've been using these scripts for a long time, and I think its about
time I understood exactly whats going on. If there was no Google, how
could I independantly look at whats available in the hidden depths of
DLLs? Could anyone explain or point me at a good article.

TIA,

Colin