It's been a long time since I did piping. I need to program a command button
in Excel to do a search in all our system directories for all Access
databases. I want the output to be dumped into Excel and separated into
columns (Name, Location, etc.)
--
Sue
Programmer/Data Analyst
Minnesota


"Harlan Grove" wrote:

"Bob Phillips" wrote...
http://tinyurl.com/ysv8eo
....

While I did read that the OP in that thread wanted an alternative to
console commands run via Shell, it's difficult to believe piping the
output from DIR through FINDSTR and possibly then through SORT
wouldn't have produced the desired result much more quickly than the
VBA alternative.