>Hi,
> I am trying to build a macro in Excel where I need the user to locate a file. I wanted to use a window like a "Save as..." windows so that he could browse through the file hierarchy and select the file he want tot use... but I don't really know how to call such window if this is possible within excel.

David, check out VBA Help for Dialog object

From help:


Using the Dialog Object

Use Dialogs(index), where index is a built-in constant identifying the dialog box, to return a single Dialog object. The following example runs the built-in Open dialog box (File menu). The Show method returns True if Microsoft Excel successfully opens a file; it returns False if the user cancels the dialog box.

dlgAnswer = Application.Dialogs(xlDialogOpen).Show