C
Cydonio
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
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