macro to displyay files

[bayguy]

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

 

[JPDO]

Hi,

Have you tried the method GETOPENFILENAME ?

Kind regards

 

[stevebausch]

Try this:


application.Dialogs.Item(xlDialogOpen).Show


I am too lazy to explain the optional arguments.