VBA to Show Directory of Doc Files

[WayneK]

Hello. Could you please share with me the VBA code that will
show a list of all the doc files within a directory, allowing you
to make a selection. (I think this is called a dialog box). And then,
once a file choice has been made, it will open that file, and store
the file's path and name to variable xfile.

Thank you for your help.

Wayne

 

[Jonathan West]

Hello. Could you please share with me the VBA code that will
show a list of all the doc files within a directory, allowing you
to make a selection. (I think this is called a dialog box). And then,
once a file choice has been made, it will open that file, and store
the file's path and name to variable xfile.

Thank you for your help.

Wayne

Look up the FileDialog object in VBA Help.