changing the title of an 'application.dialog(xldialogopen)'

R

Reiner Giesen

Hello

using the <application.dialog(xldialogopen).show "path\filename"> including the <path> and <filename> runs very well. In that case I have the possibility navigating the user close to his file. The field "Filename" is filling too, which is very important for me

Because of opening severial files, I'd like to say the user which file he has to open with the open-dialog. Is there any possibility to change the title of this dialog

On the other hand: <Application.GetOpenFilename("(*.xls),*.xls ", , "New Title!!!")> changes the title. In my mind there is no possibility to set the field "Filename". Is that right

Thanks for answers
Regard
Reiner
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word Template where user inputs <TITLE> and then that can be displayed in footers or headers [MAC] 0
Open Workbook Question 1
Workbooks.Open using Dialog box 1
Insert Multiple Fields without Dialog closing between each... 0
Using cmdlg xlDialogOpen 2
Word macro that can call cells out of Excel for a find and replace 0
Capturing 'Cancel' on Applicaiton.Dialogs(xlDialogOpen).Show FilePathAndName 4
xlDialogOpen arguments 11

Top