OK, this is awesome. Thank you, tclere.
In Excel, through VBA, you can use
to find the file, etcetc. But when I try this in VB, first "lookin" doesn't capitalize and I also get a "need object" error.
I tried adding references, no good. Anybody know what I'm missing?
Thanks again.
Mike Kemp
kempmike65@aol.com [sig][/sig]
In Excel, through VBA, you can use
Code:
set fs=application.filesearch
fs.lookin="path\filename"to find the file, etcetc. But when I try this in VB, first "lookin" doesn't capitalize and I also get a "need object" error.
I tried adding references, no good. Anybody know what I'm missing?
Thanks again.
Mike Kemp
kempmike65@aol.com [sig][/sig]
