How to change Titlel of Dialog Box?

[Naman.Patel]

I am using this code to show dialog box and I want to change title of dialog
box from "Open" to "Xyz"

Set fd = Application.Dialogs(xlDialogOpen)
fd.show

 

[Norman Jones]

Hi Naman,

Look at the GetOpenFilename method in VBA help.