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

Maybe you could use a pattern of *.DTL

It worked ok for me in xl2003 and winXP home.

(I'm not sure if it's an excel difference or a windows difference.)

Cydonio wrote:

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

--

Dave Peterson

I already tried *.DTL but got the same thing, an empty list. I tried all
kinds of patterns but none of them work. I think it might have something to
do with the actual file names containing more than one dot in them. That
situation also prevents me from reading the files using ADO. By the way, I
cannot change the naming standard of the files.


"Dave Peterson" wrote:

Maybe you could use a pattern of *.DTL

It worked ok for me in xl2003 and winXP home.

(I'm not sure if it's an excel difference or a windows difference.)

Cydonio wrote:

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

--

Dave Peterson

It worked ok for me in xl2003 and winXP home.

What version of Windows are you using? Maybe someone using the same version of
windows could try it.

Cydonio wrote:

I already tried *.DTL but got the same thing, an empty list. I tried all
kinds of patterns but none of them work. I think it might have something to
do with the actual file names containing more than one dot in them. That
situation also prevents me from reading the files using ADO. By the way, I
cannot change the naming standard of the files.

"Dave Peterson" wrote:

Maybe you could use a pattern of *.DTL

It worked ok for me in xl2003 and winXP home.

(I'm not sure if it's an excel difference or a windows difference.)

Cydonio wrote:

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

--

Dave Peterson


--

Dave Peterson