' Netzlaufwerkfunktionen per Dialog

#If VBA7 Then
    'Code für 32 bit und 64 bit Office VBA 7
     #If Win64 Then
        'Code für 64-bit Office VBA 7
        Declare PtrSafe Function WNetConnectionDialog Lib "mpr.dll" _
            (ByVal hwnd As LongPtr, ByVal dwType As Long) As Long
        Declare PtrSafe Function WNetDisconnectDialog Lib "mpr.dll" _
            (ByVal hwnd As LongPtr, ByVal dwType As Long) As Long
        Declare PtrSafe Function WNetAddConnection Lib "mpr.dll" Alias "WNetAddConnectionA" _
            (ByVal lpszNetPath As String, ByVal lpszPassword As String, ByVal lpszLocalName As String) As Long
        Declare PtrSafe Function WNetCancelConnection Lib "mpr.dll" Alias "WNetCancelConnectionA" _
            (ByVal lpszName As String, ByVal bForce As Long) As Long
     #Else
        'Code für 32-bit Office VBA 7
        Public Declare Function WNetConnectionDialog Lib "mpr.dll" ( _
            ByVal hWnd As Long, _
            ByVal dwType As Long) As Long
        Public Declare Function WNetDisconnectDialog Lib "mpr.dll" ( _
            ByVal hWnd As Long, _
            ByVal dwType As Long) As Long
        ' Netzlaufwerkfunktionen ohne Dialog
        Public Declare Function WNetAddConnection Lib "mpr.dll" _
            Alias "WNetAddConnectionA" ( _
            ByVal lpszNetPath As String, _
            ByVal lpszPassword As String, _
            ByVal lpszLocalName As String) As Long
        Public Declare Function WNetCancelConnection Lib "mpr.dll" _
            Alias "WNetCancelConnectionA" ( _
            ByVal lpszName As String, _
            ByVal bForce As Long) As Long
     #End If
#Else
    'Code für VBA 6 (32 bit)
    Public Declare Function WNetConnectionDialog Lib "mpr.dll" ( _
        ByVal hWnd As Long, _
        ByVal dwType As Long) As Long
    Public Declare Function WNetDisconnectDialog Lib "mpr.dll" ( _
        ByVal hWnd As Long, _
        ByVal dwType As Long) As Long
' Netzlaufwerkfunktionen ohne Dialog
    Public Declare Function WNetAddConnection Lib "mpr.dll" _
        Alias "WNetAddConnectionA" ( _
        ByVal lpszNetPath As String, _
        ByVal lpszPassword As String, _
        ByVal lpszLocalName As String) As Long
    Public Declare Function WNetCancelConnection Lib "mpr.dll" _
        Alias "WNetCancelConnectionA" ( _
        ByVal lpszName As String, _
        ByVal bForce As Long) As Long
#End If

Public Const RESOURCETYPE_DISK = &H1
Public Const WN_Success = &H0
Public Const WN_Net_Error = &H2
Public Const WN_Bad_Password = &H6
Public Const WN_Access_Denied = &H7
Public Const WN_Already_Connected = &H34
Public Const WN_Bad_NetName = &H32

Public Function API_DeleteFile(strFile As String) As Long
'*******************************************
'Name:      API_DeleteFile (Function)
'Purpose:   Datei löschen
'Author:    Tommyk
'Date:      März 11, 2004, 04:05:37
'Inputs:    strFile=Pfad und Name der Quelldatei
'Output:
'*******************************************
   API_DeleteFile = DeleteFile(strFile)
   If API_DeleteFile = 0 Then
      MsgBox "Löschen der Datei " & strFile & " Fehlgeschlagen", vbInformation, "Fehler"
      Exit Function
   Else
      MsgBox "Die Datei wurde erfolgreich gelöscht.", vbInformation, "Erfolgreich"
   End If
End Function

Dim lResult As Long
lResult = WNetConnectionDialog(Me.hWnd, _
    RESOURCETYPE_DISK)

Dim lResult As Long
lResult = WNetDisconnectDialog(Me.hWnd, _
    RESOURCETYPE_DISK)

Public Function Connect_NetDrive(sDriveLetter As String, _
    sNetworkPath As String, _
    Optional sPWD As String = vbNullString) As Boolean
    Dim lResult As Long
    lResult = WNetAddConnection(sNetworkPath, _
        sPWD, sDriveLetter)
    If lResult <> WN_Success Then
        Select Case lResult
            Case WN_Net_Error
                MsgBox "Netzwerkfehler!"
            Case WN_Bad_Password
                MsgBox "Ungültiges Passwort!"
            Case WN_Access_Denied
                MsgBox "Zugriff verweigert"
            Case WN_Already_Connected
                MsgBox "Laufwerk ist bereits verbunden"
            Case WN_Bad_NetName
                MsgBox "Der Netzwerkpfad wurde nicht gefunden"
            Case Else
                MsgBox "Unbekannter Fehler"
        End Select
    End If
    Connect_NetDrive = (lResult = WN_Success)
End Function

Connect_NetDrive "E:", "\\PC-Name\Freigabename"

Connect_NetDrive "E:", \\PC-Name\Freigabename, "geheim"

Public Function Disconnect_NetDrive(sDriveLetter As String) As Boolean
    Dim lResult As Long
    lResult = WNetCancelConnection(sDriveLetter, True)
    If lResult <> WN_Success Then
        If lResult = WN_Net_Error Then
            MsgBox "Netzwerkfehler!"
        Else
            MsgBox "Unbekannter Fehler"
        End If
    End If
    Disconnect_NetDrive = (lResult = WN_Success)
End Function

Disconnect_NetDrive "K:"

• Suchen und Einlesen von Dateien mit MS-Access II
• Ermitteln und Beenden von externen Programmen
• Arbeiten mit EXIF-Tags
• Verzeichnisgröße ermitteln, wahlweise mit oder ohne Unterverzeichnisse
• MP3 Tags lesen und bearbeiten