Questions about Application.FileDialog

[SeaLyon]

I need the user to select a destination folder and was thinking about using Application.FileDialog(msoFileDialogFolderPicker). This appears to work, but the buttons along the left & top of the displayed dialog are not active. Is there a way to enable these buttons? If not, what other dialog display options are available from VBA that would allow me to display & use a fully functional select folder dialog?

Here's the basic code I'm using:

  With Application.FileDialog(msoFileDialogFolderPicker)
    .Title = "Select Destination Folder for Recipe Export File"
    .ButtonName = "Select Folder"
    If .Show = True Then
      iResp = MsgBox(.SelectedItems(1), vbOKOnly)
    End If
  End With

Here's the displayed dialog:

Any help is appreciated.

Thanks,
Chris

 

[tweedle]

I had no issues with this.
[XL2007 on Win7.]

 

[SeaLyon]

This appears to be an issue with the combination of XP (SP3) & Excel 2010. As I originally stated, the dialog buttons are NOT active when I run this under Excel 2010 on XP. However, if I run this using Excel 2003 on XP, the dialog buttons work correctly. Does anyone know if there are known issues with Excel 2010 on XP? I've been running the XP/Excel2010 combination for a while and this is the first problem I've seen.

 

[LydiaF]

This appears to be an issue with the combination of XP (SP3) & Excel 2010. As I originally stated, the dialog buttons are NOT active when I run this under Excel 2010 on XP. However, if I run this using Excel 2003 on XP, the dialog buttons work correctly. Does anyone know if there are known issues with Excel 2010 on XP? I've been running the XP/Excel2010 combination for a while and this is the first problem I've seen.

FYI This worked with XP and Excel 07