Check if .execute method is successful for a file dialog

[eAlchemist]

Anyone know how to easily check to see if the .execute method was successful after a user selects a file in a file dialog? If the user selects a file already opened, they can opt out of opening it, so the .show = false won't work (because the selected a file, but the failure comes on the open). And, I can't access the .SelectedItems with msoFileDialogOpen to test if the file is open.

Thanks,
Chris

 

[firefytr]

If you're looking for getting a file name and it's for Excel, I recommend you using the GetOpenFilename method instead of using a dialog box, you have much more control over it that way.

If you need more help, please post back.

Regards,
Zack Barresse

Simplicity is the ultimate sophistication. What is a MS MVP? PODA
- Leonardo da Vinci