Hi all - hoping for a bit of advice.

Working on tool to check population of server drive; all subfolders &
files (multi format). Have been using macro button/VBA to run shell DOS
command (dir + switches) to return alphabetical list inc sub-directories
+ files plus their extension ie. Everything c3000 lines). The DOS
command outputs to file “data.xls”. Next button/VBA gets data from
“data.xls” and pastes values into column A of tool worksheet (“data”)
named range “listing”. I then use a countif wildcard function to search
"listing" and populate a conditionally formatted matrix.

It works (albeit slowly) but you can see its not elegant and I get
annoying messages about data on clipboard. I am hoping that there is a
VBA method of populating my data worksheet ……any ideas.

D:-)


--
Digory
------------------------------------------------------------------------
Digory's Profile: http://www.excelforum.com/member.php...o&userid=16439
View this thread: http://www.excelforum.com/showthread...hreadid=474447