Excel 2010 64-bit Browse for folder Dialog box

Hi,
One of my client uses Excel 2010 64 bit version. The following code runs perfectly on all the 32-bit versions of Excel. It is to open the dialog box to specify location to save the file.

lpIDList = SHBrowseForFolder(tBrowseInfo)

But now the excel stops functioning after coming to this code. I have to close the program and restart it.

Does anyone know of this problem?

Thanks & Regards,
Vaibhav

64 bit Excel does not always play well with APIs.

Use this approach instead, works in 2003 as well

    With Application.FileDialog(msoFileDialogFolderPicker)
    
        .AllowMultiSelect = False
        If .show = -1 Then

            MsgBox .SelectedItems(1)
        End If
    End With