Open file based on user selection

Found it! I just needed to add the ChDir line before the GetOpenFilename. Here's the code that worked:

    On Error GoTo NoPO
    ChDir "M:\Archived PO Responses\Processed\"
    NewFN = Application.GetOpenFilename(FileFilter:="Excel Files (*.xls), *.xls", Title:="Please select a file")
    If NewFN = False Then
    'They pressed Cancel
    MsgBox "Stopping because you did not select a file"
    Exit Sub
    Else
    Workbooks.Open Filename:=NewFN
    End If
    On Error GoTo 0

Have a good one.

Okay, I was wrong. This isn't solved.

Adding the ChDir line worked on my computer, but for some reason when I runt he macro on another computer, it still defaults to the My Computer directory when the select file dialog opens up. Is there another line I need to add, or what?

This worked on the other computer:

    ChDrive "M:\Archived PO Responses\Processed"
    ChDir "M:\Archived PO Responses\Processed"
    NewFN = Application.GetOpenFilename(FileFilter:="Excel Files (*.xls), *.xls", Title:="Please select a file")
    If NewFN = False Then
    'They pressed Cancel
    MsgBox "Stopping because you did not select a file"
    Exit Sub
    Else
    Workbooks.Open Filename:=NewFN
    End If