这种文件选择框是怎么创建的
这种文件选择框是如何创建的
这个是office2007的打开对话框，哪位大神创建过这样的文件选择框啊，大体创建流程告诉下就可以~
------解决思路----------------------
还真没关系，是我弄混了。
不过这个对话框可以调用Office2007的
ms-help://MS.VSCC.v90/MS.MSDNQTR.v90.chs/officedev2007/content/HV10075180.htm
Office Developer Reference
FileDialog.Show Method
Displays a file dialog box and returns a Long indicating whether the user pressed the Action button (-1) or the Cancel button (0). When you call the Show method, no more code executes until the user dismisses the file dialog box. In the case of Open and SaveAs dialog boxes, use the Execute method right after the Show method to carry out the user's action.
Syntax
expression.Show
expression Required. A variable that represents a FileDialog object.
Example
The following example displays a File Picker dialog box using the FileDialog object and displays each selected file in a message box.
Visual Basic for Applications
Sub Main()
'Declare a variable as a FileDialog object.
Dim fd As FileDialog
'Create a FileDialog object as a File Picker dialog box.
Set fd = Application.FileDialog(msoFileDialogFilePicker)
'Declare a variable to contain the path
'of each selected item. Even though the path is aString,
'the variable must be a Variant because For Each...Next
'routines only work with Variants and Objects.
Dim vrtSelectedItem As Variant
'Use a With...End With block to reference the FileDialog object.
With fd
'Use the Show method to display the File Picker dialog box and return the user's action.
'The user pressed the button.
If .Show = -1 Then
'Step through each string in the FileDialogSelectedItems collection.
For Each vrtSelectedItem In .SelectedItems
'vrtSelectedItem is a string that contains the path of each selected item.
'You can use any file I/O functions that you want to work with this path.
'This example displays the path in a message box.
MsgBox "The path is: " & vrtSelectedItem
Next vrtSelectedItem
'The user pressed Cancel.
Else
End If
End With
'Set the object variable to nothing.
Set fd = Nothing
End Sub
See Also
FileDialog Object
FileDialog Object Members
这个是office2007的打开对话框，哪位大神创建过这样的文件选择框啊，大体创建流程告诉下就可以~
------解决思路----------------------
还真没关系，是我弄混了。
ms-help://MS.VSCC.v90/MS.MSDNQTR.v90.chs/officedev2007/content/HV10075180.htm
Office Developer Reference
FileDialog.Show Method
Displays a file dialog box and returns a Long indicating whether the user pressed the Action button (-1) or the Cancel button (0). When you call the Show method, no more code executes until the user dismisses the file dialog box. In the case of Open and SaveAs dialog boxes, use the Execute method right after the Show method to carry out the user's action.
Syntax
expression.Show
expression Required. A variable that represents a FileDialog object.
Example
The following example displays a File Picker dialog box using the FileDialog object and displays each selected file in a message box.
Visual Basic for Applications
Sub Main()
'Declare a variable as a FileDialog object.
Dim fd As FileDialog
'Create a FileDialog object as a File Picker dialog box.
Set fd = Application.FileDialog(msoFileDialogFilePicker)
'Declare a variable to contain the path
'of each selected item. Even though the path is aString,
'the variable must be a Variant because For Each...Next
'routines only work with Variants and Objects.
Dim vrtSelectedItem As Variant
'Use a With...End With block to reference the FileDialog object.
With fd
'Use the Show method to display the File Picker dialog box and return the user's action.
'The user pressed the button.
If .Show = -1 Then
'Step through each string in the FileDialogSelectedItems collection.
For Each vrtSelectedItem In .SelectedItems
'vrtSelectedItem is a string that contains the path of each selected item.
'You can use any file I/O functions that you want to work with this path.
'This example displays the path in a message box.
MsgBox "The path is: " & vrtSelectedItem
Next vrtSelectedItem
'The user pressed Cancel.
Else
End If
End With
'Set the object variable to nothing.
Set fd = Nothing
End Sub
See Also
FileDialog Object
FileDialog Object Members