Get Full File Path and File Name

dinoc

Registered User.
Local time
Today, 15:17
Joined
Oct 23, 2014
Messages
13
Good Evening Word.

I'm having another one of those days but I'm getting a file path and file name from a dialogbox and forgotten when the VBA property is to return the full file path and file name.

This code works fine for return the filename only:
Code:
Private Sub TEST()
Dim f As Object
Set f = Application.FileDialog(3)
f.AllowMultiSelect = True
 
If f.Show Then
    For I = 1 To f.SelectedItems.Count
        MsgBox Filename(f.SelectedItems(I))
    Next
End If
End Sub

Instead of using 'Filename' what else can I use to return what I need?

If that makes sense?

Thanks in advance.
Dino
 
Use nothing . . .
Code:
MsgBox f.SelectedItems(I)
That shows the full path.
 
Use nothing . . .
Code:
MsgBox f.SelectedItems(I)
That shows the full path.

Wow I really am having a "special" moment today.

Thank you MarkK
 

Users who are viewing this thread

Back
Top Bottom