Public Sub openme() Dim filename As String Dim fso As New FileSystemObject Dim sh As Object filename = ActiveCell.Value If fso.GetExtensionName(filename) = "xls" Or fso.GetExtensionName(filename) = "xlsx" Then Call Workbooks.Open(filename) Exit Sub End If If fso.GetExtensionName(filename) = "js" Then Shell "C:\Program Files (x86)\sakura\sakura.exe " & filename Exit Sub End If If fso.GetExtensionName(filename) = "xml" Then Shell "C:\Program Files (x86)\sakura\sakura.exe " & filename Exit Sub End If If fso.GetExtensionName(filename) = "bat" Then Shell "C:\Program Files (x86)\sakura\sakura.exe " & filename Exit Sub End If 'Set sh = CreateObject("Shell.Application") 'Call sh.Open(filename) Shell "explorer.exe " & filename End Sub Public Sub showInExplorer() Dim filename As String Dim fso As New FileSystemObject Dim sh As Object filename = ActiveCell.Value filename = "C:\workspace\" & Replace(filename, "/", "\") If fso.GetExtensionName(filename) = "xls" Or fso.GetExtensionName(filename) = "xlsx" Then Call Workbooks.Open(filename) Exit Sub End If Shell "explorer.exe /select," & filename, vbNormalFocus End Sub |
投稿 >