P
Pam
The code below show the file path in a message box, how do I change it
to show the file path in a label on a user form?
Do I reference the label name?
I am using a command button to run it in Word 2003 XP.
Thanks
Pam
Dim fd As FileDialog
Set fd = Application.FileDialog (msoFileDialogFilePicker)
Fd.InitialFileName = \\ushou1fp003\wordp\Contracts\
Dim vrtSelectedItem As Variant
With fd
If .Show = -1 Then
For Each vrtSelectedItem In .SelectedItems
MsgBox "The path is: " & vrtSelectedItem
Next vrtSelectedItem
Else
End If
End With
End Sub
to show the file path in a label on a user form?
Do I reference the label name?
I am using a command button to run it in Word 2003 XP.
Thanks
Pam
Dim fd As FileDialog
Set fd = Application.FileDialog (msoFileDialogFilePicker)
Fd.InitialFileName = \\ushou1fp003\wordp\Contracts\
Dim vrtSelectedItem As Variant
With fd
If .Show = -1 Then
For Each vrtSelectedItem In .SelectedItems
MsgBox "The path is: " & vrtSelectedItem
Next vrtSelectedItem
Else
End If
End With
End Sub