Solved

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

Posted on 2002-04-09
1
334 Views
Last Modified: 2007-12-19
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.
0
Comment
Question by:WanNing
1 Comment
 
LVL 44

Accepted Solution

by:
bruintje earned 200 total points
ID: 6930431
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

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
This video shows the viewer how to set up and create Footnotes in their document. Click on the References tab: Select "Insert Footnote": Type in desired text:
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question