AW: über Excel Tabelle Ordner öffnen
02.09.2020 15:08:08
Nepumuk
Hallo Ylmz,
kein Problem:
Option Explicit
Private Const FOLDER_PATH As String = "C:\Users\Technik\Pictures\Akten\"
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Dim strFoldername As String, strAlternativeFoldername As String
If Target.Column = 2 Then
strAlternativeFoldername = Replace(Replace(Target.Text, "-", "_"), "/", "-")
strFoldername = Dir$(FOLDER_PATH & "*" & _
Replace(Target.Text, "/", "-") & "*", vbDirectory)
If strFoldername = vbNullString Then strFoldername = _
Dir$(FOLDER_PATH & "*" & strAlternativeFoldername & "*", vbDirectory)
If strFoldername <> vbNullString Then
Call Shell("explorer.exe /e, " & FOLDER_PATH & strFoldername, vbNormalFocus)
Else
Call MsgBox("Ordner nicht gefunden.", vbExclamation, "Hinweis")
End If
Cancel = True
End If
End Sub
Gruß
Nepumuk