My code needs to know the path and filename to a workbook for later use. The
info is to be provided by the user.

I tried to use:

Application.Dialogs(xlDialogOpen).Show

but that only returns the value true or false.

I still want the dialog to show but instead of true or false I want the
dialog to return the path and filename to the workbook. Also I don't want
the file to open - I just need the path info.

Any ideas?

TIA
PO