I am using

Application.Dialogs(xlDialogOpen).Show
but I would like to change the title of the dialog window. I tried refering to getopenfilename method (Title argument), but couldn't have something that compiles!



Also, when the user selects the file to open, is there a way to store the name of the file as a string for futur use? (Lets use
Dim NameofFile as string
)

Thanks,

Annie