Hello,
When I add the .InitialFileName for Application.FileDialog(msoFileDialogOpen), only part of the file is displayed. See screenshot attached. I've seen some solutions online, but I've yet to find one that works. Does anyone know a way around this, please? Here is my code:
Code:
Sub testOpen()
With Application.FileDialog(msoFileDialogOpen)
.Filters.Clear
.Filters.Add "Word Files", "*.doc*", 1
.InitialFileName = "C:\Users\roy\OneDrive\Desktop\test_files\test_file_one.docm"
If .Show = -1 Then
strFile = .SelectedItems(1)
End If
End With
If strFile = "" Then
Exit Sub
End If
End Sub