Using the following I can open a window showing the files in that directory;

Application.Dialogs(xlDialogOpen).Show "\\Rfp_main\rfp2005\templates"

However if someone tries to load a file ... say Word.. in that directory,
excel tries to import it into the open workbook. How can I rempve the focus
back to the workbook and close it, thus leaving only the open window on the
desktop with excel now closed down ?

Thanks
--
Robert Pollock