fname = Application.GetOpenFileName()

shows the file open dialog and allows traversing directories to find or
establish the location of the file.

for saving

fName = Application.GetSaveAsFileName()

Note that neither of these open or save the file selected - they return the
fully qualified name as a string

--
Regards,
Tom Ogilvy


"DorisM" wrote in message
...
I'm trying to create a command button using VBA in an excel sheet that
opens
up "My Computer". So it will allow the user to go to whatever folder that
they have their file saved at. Similar to the "Open" command in most
window
applications.

I'm at level I in VBA, so I'm not sure if this is possible.

Thank you.

Doris