View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Interacting outside Excel

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