Diablo II
Well-known Member
- Joined
- Sep 28, 2008
- Messages
- 538
Hi
I use office 2003 at home and i can use this to open the open file in it.
Private Sub CommandButton1_Click()
With Application.FileDialog(msoFileDialogOpen)
.AllowMultiSelect = True
.Show
For lngCount = 1 To .SelectedItems.Count
MsgBox .SelectedItems(lngCount)
Next lngCount
End With
End Sub
and i use to know the one to use for ofice 2000, but i can not remimber it
and i wont to use it on a userForm to look in a public drive G at all files in a folder.
thanks for your help
I use office 2003 at home and i can use this to open the open file in it.
Private Sub CommandButton1_Click()
With Application.FileDialog(msoFileDialogOpen)
.AllowMultiSelect = True
.Show
For lngCount = 1 To .SelectedItems.Count
MsgBox .SelectedItems(lngCount)
Next lngCount
End With
End Sub
and i use to know the one to use for ofice 2000, but i can not remimber it
and i wont to use it on a userForm to look in a public drive G at all files in a folder.
thanks for your help