multiple dir command outs to same excel spreadsheet, different worksheet

F

finleyl

How can I direct the output of multiple dir commands (listing director
contents) to the same spreadsheet, but separate worksheets?

IE
dir v:\drawings
dir v:\documents

I want the output pf each dir command to go to the same spreadshee
-"contents of V directory" -but I want each dir output to go to
separate worksheet within the spreadsheet. What would be the synta
within my dir command?

Thank
 
Top