macro to displyay files

bayguy

New Member
Joined
Sep 14, 2002
Messages
1
I am looking for a macro to display the files in a specific folder that the user has the option to open. This is similar for the File-Open from the menu bar
 

Some videos you may like

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

JPDO

Board Regular
Joined
Apr 10, 2002
Messages
140
Hi,

Have you tried the method GETOPENFILENAME ?

Kind regards
 

stevebausch

Well-known Member
Joined
May 11, 2002
Messages
810
Try this:


application.Dialogs.Item(xlDialogOpen).Show


I am too lazy to explain the optional arguments.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,079
Messages
5,570,083
Members
412,310
Latest member
mark884
Top