(xlDialogOpen)

[ireland13752]

Hello, Happy Monday... HAHA! Oxymoron....

I need to add a name to the dialog box that opens with the below code. I do not want it to say "Open". I want it to say "Open Anchor File". Please help. Here is the code.

MsgBox Application.Dialogs(xlDialogOpen).Show(arg1:=Filename)

I know it is in the "XLDialogOpen", but I do not know what to put instead. I have tried a few things and looked for help, to no avail...

 

[Debraj]

Hi..

NO.. this commonDilaogBox dont have enough option to change the tite..

If you have prior knowledge in vba.. you can check this function..

filename = application.GetOpenFilename(,,"Open Anchor File")

It will work same as
Application.Dialogs(xlDialogOpen).Show

 

[ireland13752]

Thank you Debraj. This worked perfectly! I appreciate your help!