I am using the macro below to retreives the path and filename of a file
that I select from the File Open dialog box

How can I tweak this macro so that the dialog box always opens in the
C:\Employee Performance\ directory?

Any help would be much appreciatted


Sub GetFileName()
Dim sFileName As String

sFileName = Application.GetOpenFilename
If sFileName = "False" Then Exit Sub
ThisWorkbook.Activate
Range("a1").Value = sFileName
End Sub


--
Papa Waigo
------------------------------------------------------------------------
Papa Waigo's Profile: http://www.excelforum.com/member.php...o&userid=36074
View this thread: http://www.excelforum.com/showthread...hreadid=560059