run DOS command in excel
Lookup the Shell comand in the VBA help file example of running Dos command; Sub RemoveDir_WithFiles() Shell "command.com /c RD C:mydir" End Sub Note: In Microsoft Excel, when you use the Shell function in a VBA macro to execute an external MS-DOS ......