一、
Sub dfsdfsF()
Set dig = Application.FileDialog(msoFileDialogOpen)
With dig
.AllowMultiSelect = True
.Filters.Add "文本文件", "*.txt", 1
.InitialFileName = "g:\123\"
.InitialView = msoFileDialogViewDetails
.Title = "打开"
.Show
.Execute
End With
Set dig = Nothing
End Sub
选择文本文件打开后,却是以excel来打开的,怎么做,才是以其自身方式打开,如txt以记事本来打开?
二、
Sub df0999088dfsF()
Dim dig As Object
Set dig = Application.FileDialog(msoFileDialogFilePicker)
With dig
.InitialView = msoFileDialogViewLargeIcons
.Title = "打开"
.Show
For Each f In .SelectedItems
MsgBox f
Next f
End With
Set dig = Nothing
End Sub
2003中随着msofiledialogview的变化,文件夹的预览会有变化,而在2013中不管怎么变,都是details样式。怎么办
第一个问题也解决了,代码如下:
Sub 打开文件()
With Application.FileDialog(msoFileDialogOpen)
.AllowMultiSelect = True
.Filters.Add "文本文件", "*.txt", 1
.InitialFileName = "g:\123\"
.InitialView = msoFileDialogViewLargeIcons
.Title = "打开"
If .Show = 0 Then Exit Sub
For x = .SelectedItems.Count To 1 Step -1
Shell "notepad " & .SelectedItems(x), 1
Next x
End With
End Sub