It happens that Hello formulated :
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.

Uh.., you can't delete an open file so that's not going to fly!

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc