I need to map to a network Share ´(i.e.: "\\192.168.100.1\Data") to access some Excel Sheets, but i am only able to open the Windows default mapping Dialog within my macro - SH** :-(
Is there a way to map and later disconnect Shares / Drives completely?

MY MACRO:
Option Explicit

Private Declare Function wnetconnectiondialog Lib "mpr.dll" Alias "WNetConnectionDialog" (ByVal hwnd As Long, ByVal dwType As Long) As Long
Sub NetzlaufwerkVerbinden()
Dim L As Long
Dim hwnd As Long
L = wnetconnectiondialog(hwnd, 1)
End Sub