Use the ChDir statement (and perhaps ChDrive as well if you need a different
drive) to switch to the directory you want before you execute the
GetOpenFileName line.

On Mon, 11 Oct 2004 15:41:10 -0700, "Heath"
wrote:

I have tried to use the GetOpenFilename application in VBA so that I would be
able to get the Open dialog box to display at a specified place but it will
only display the open dialog box of the last file opened is there a
application or another method of getting the Open file dialog box to display
at a specific place or not? Thank you

Heath