View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_2_] Dave Peterson[_2_] is offline
external usenet poster
 
Posts: 420
Default How can delete file by Marco


Activeworkbook.ChangeFileAccess Mode:=xlReadOnly
kill activeworkbook.fullname



On 02/11/2011 22:35, Hello wrote:
I also need to delete the file (have / include file name "test") if
the file is open too (active workbook). And don't want to shown the
pop up message on the screen.


--
Dave Peterson