how can get the filename or fileformat or directory in xlDialogOpen of EXCEL?

hello, everyone.

If I used followed statement in EXCEL,
    Application.Dialogs(xlDialogOpen).Show arg3:=True
it can popup a file-open-dialog and open a file with read-only.

 But how can I get the args which selected in the file-open-dialog?

QUESTION:
1.  I want to GET the all args value which set in file-open-dialog, i.e. , if i changed directory in file-open-dialog, how to get the directoryname after press "OK"?

2.  where can get the explanation of all args such as file_text, update_links, read_only, format, ...


best regards.
WanNingAsked:
Who is Participating?
 
bruintjeCommented:
Hi WanNing,

here's a list of the arguments you can show or use

file_text, update_links, read_only, format, prot_pwd, write_res_pwd, ignore_rorec, file_origin, custom_delimit, add_logical, editable, file_access, notify_logical, converter

you see arg3 = read_only

the part of the filename to open

fileToOpen = ApplicationGetOpenFilename()
or
fileToOpen = ApplicationGetOpenFilename("Text Files (*.txt), *.txt")

HTH:O)Bruintje
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.