Sub GetMGAM_Files()


MGAMFileName = Application.GetOpenFilename("Excel Files (*.xls),*.xls",
, Title:=" Select MGAM File to Import")

' Exit if dialog box canceled
If MGAMFileName = False Then
MGAMFileStop = MsgBox(" No file was selected. Would you like to end
the reconciliation process.?", vbYesNo, "Question")
If MGAMFileStop = vbNo Then
GetMGAM_Files
Else
RecBook.Close (False)
End
End If
End If


The reason I am considering doing it this way is that sometimes when I
insert my USB flash, though it is recognized by the CPU, if I bring up
the open dialog box in Excel immediately after, the drive letter won't
be in the dialog box. But the second time I bring up the open dialog
box the drive is there.