View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Cydonio Cydonio is offline
external usenet poster
 
Posts: 2
Default Open file dialog box works in XL2000 but not in XL2003

Hi all,
I have this code working fine in an Excell 2000 macro:

Sheets("SF.LMI.LOAN.DTL").Activate
filePath = Application.GetOpenFilename("Load LOAN detail Files
(*.LOAN.DTL), *.LOAN.DTL", , "Select a Loan Detail file")
If filePath = False Then
Exit Sub
End If

The code shows the Open File dialog box, displaying only the name of the one
particular file I want to show to the user. However, it does not work in
XL2003. When the box is displayed XL2003, the list of files is empty. So, I
have to change the pattern for the file name to *.*, which displays all the
files in the directory.
Does anyone know why it does not work the same in XL2003?

Thanks in advance