[RESOLVED] [Excel] Having problems with .InitialFileName view with FileDialog command

[ddiaz]

So I am using the FileDialog to select a folder full of images that I am putting into a PowerPoint presentation and I am having problems getting the right initial view to come up.

Here is what I have

strFolder = InitDir
Set fldr = Application.FileDialog(msoFileDialogFolderPicker)

With fldr
.Title = "Select a Folder"
.AllowMultiSelect = False
.ButtonName = "Select"
.InitialView = msoFileDialogViewList
.InitialFileName = "C:\Users\Daniel\My Pictures\" 'using to test code

If Right(strName, 1) <> "\" Then
strFolder = strFolder & "\"
End If
If .Show <> -1 Then
Exit Sub
Else
strFolder = .SelectedItems(1) & "\"
End If
End With

If I exlude the "\" after "My Pictures", all the folders in my user folder "Daniel" comes up in the initial view with "My Pictures" initially selected, but when I include the "\" after, what I presume is the "FileDialogViewList" just shows up. How do I get the "My Pictures" folder to come up initially.

[westconn1]

all the folders in my user folder "Daniel" comes up in the initial view

do you have folders in "My Pictures"?

[ddiaz]

Yes I do have folders in "My Pictures". I have also tried to go farther into the path to include one of the folders in "My Pictures" and one of the files in that folder, but run into the same problem. Whenever I was working on this at work I ran into the same problem. It's like it will only allow you to set the initialfilename at two folders into the drive if that makes sense. Like C:\1\2\ but not C:\1\2\3 or more. Is this just a limitation of using FileDialog or is there something I am missing.

[ddiaz]

I figured it out after I checked the properties of one of my folders in "My Pictures". The actual filepath used just "Pictures" instead of "My Pictures" as it shows Windows Explorer. Sneaky sneaky windows 7.