opening files
 

Try this

Application.Dialogs(xlDialogOpen).Show


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Brian" wrote in message ...
How do I write the VBA code to prompt the user to select a
file to open? In other words, I want the code to make
the Excel 'Open' window appear in order for the user to
browse for the appropriate file to open.

Thanks in advance!

Brian