I have two requirements i'm not sure how to handle.

The first is that I need to delete all files in a
directory. I want to tell Excel the path and delete *.*
in that directory.

The second is that I need to call an external
application. It is a basic .bat file, but I amunsure how
to call it from VB.

Thanks

Kevin

kill "C:\Myfolder\*.*"

look in help at the shell command (vba help)

--
Regards,
Tom Ogilvy


"Kevin" wrote in message
...
I have two requirements i'm not sure how to handle.

The first is that I need to delete all files in a
directory. I want to tell Excel the path and delete *.*
in that directory.

The second is that I need to call an external
application. It is a basic .bat file, but I amunsure how
to call it from VB.

Thanks

Kevin