Sorry, got a little happy with the enter key.

I can't get this to work with the mentioned combination. I
have it working fine on a Windows 2000 machine running
Office 2000, and on a Windows 95 machine running Office
97, but when I try to run it on a Windows 2000 machine
with Office 97, I get a application error. The code stops
running at the .Filename = "*.txt" line of code.

Thanks in advance for any help.
Dave

-----Original Message-----
Hi,
Set fs = Application.FileSearch

With fs
.LookIn = "C:\My Documents"
.Filename = "*.txt"
If .Execute(SortBy:=msoSortByFileName, _
SortOrder:=msoSortOrderAscending) 0 Then
MsgBox "There were " & .FoundFiles.Count & _
" file(s) found."
.

Hi Dave

Try .Text instead of *.Text

Post back if this not work for you

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Dave" wrote in message ...
Sorry, got a little happy with the enter key.

I can't get this to work with the mentioned combination. I
have it working fine on a Windows 2000 machine running
Office 2000, and on a Windows 95 machine running Office
97, but when I try to run it on a Windows 2000 machine
with Office 97, I get a application error. The code stops
running at the .Filename = "*.txt" line of code.

Thanks in advance for any help.
Dave

-----Original Message-----
Hi,
Set fs = Application.FileSearch

With fs
.LookIn = "C:\My Documents"
.Filename = "*.txt"
If .Execute(SortBy:=msoSortByFileName, _
SortOrder:=msoSortOrderAscending) 0 Then
MsgBox "There were " & .FoundFiles.Count & _
" file(s) found."
.

Ron,
That worked. Thanks alot. Why does this combination
not like the wild card?

Dave

-----Original Message-----
Hi Dave

Try .Text instead of *.Text

Post back if this not work for you

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Dave" wrote in message
...
Sorry, got a little happy with the enter key.

I can't get this to work with the mentioned
combination. I
have it working fine on a Windows 2000 machine running
Office 2000, and on a Windows 95 machine running Office
97, but when I try to run it on a Windows 2000 machine
with Office 97, I get a application error. The code
stops
running at the .Filename = "*.txt" line of code.

Thanks in advance for any help.
Dave

-----Original Message-----
Hi,
Set fs = Application.FileSearch

With fs
.LookIn = "C:\My Documents"
.Filename = "*.txt"
If .Execute(SortBy:=msoSortByFileName, _
SortOrder:=msoSortOrderAscending) 0 Then
MsgBox "There were " & .FoundFiles.Count & _
" file(s) found."
.



.

Hi Dave

I can tell you why it work this way
I have read that this is sometimes a solution.


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Dave" wrote in message ...
Ron,
That worked. Thanks alot. Why does this combination
not like the wild card?

Dave

-----Original Message-----
Hi Dave

Try .Text instead of *.Text

Post back if this not work for you

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Dave" wrote in message
...
Sorry, got a little happy with the enter key.

I can't get this to work with the mentioned
combination. I
have it working fine on a Windows 2000 machine running
Office 2000, and on a Windows 95 machine running Office
97, but when I try to run it on a Windows 2000 machine
with Office 97, I get a application error. The code
stops
running at the .Filename = "*.txt" line of code.

Thanks in advance for any help.
Dave

-----Original Message-----
Hi,
Set fs = Application.FileSearch

With fs
.LookIn = "C:\My Documents"
.Filename = "*.txt"
If .Execute(SortBy:=msoSortByFileName, _
SortOrder:=msoSortOrderAscending) 0 Then
MsgBox "There were " & .FoundFiles.Count & _
" file(s) found."
.



.