Is Common dialog box supports vba 2010 or not?

Question

i have a application which is excel 2003.This application have Common Dialog box but it is not working in vba 2010.
Is Common dialog box supports vba 2010 or not?

Answer 1

i have a application which is excel 2003.This application have Common Dialog box but it is not working in vba 2010.
Is Common dialog box supports vba 2010 or not?

Answer 2

You can prompt the user for a filename by using Application.GetOpenFileName and Application.GetSaveAsFileName.

And Application.FileDialog lets you display four dialogs:

• An open dialog
• A file picker dialog
• A folder picker dialog
• A save as dialog

Both work in Excel 2010 the same way as they do in Excel 2003.

What kind of dialog are you trying to use?

---

Regards, Hans Vogelaar

Answer 3

@Moderators: duplicate of http://social.msdn.microsoft.com/Forums/en-US/exceldev/thread/a3b38d63-db4b-471f-a5c3-e584c3a942a1 (where I posted a reply).

---

Regards, Hans Vogelaar