Filename search using Office 97 with Windows 2000

[Dave]

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

 

[Ron de Bruin]

Hi Dave

Try .Text instead of *.Text

Post back if this not work for you

 

[Dave]

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

Dave

 

[Ron de Bruin]

Hi Dave

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