Deleting file while in use

[Todd Huttenstine]

Hey guys

The Excel file I am trying to delete is the same file that
the code is in.
I know it is impossible to delete or overwrite an Excel
file that is in use by Excel. But is there anyway that
after Excel quits, it can delete itself?


Thanx
Todd Huttenstine

 

[Tom Ogilvy]

Look at the
ChangeFileAccess
method. Have your code change it to readonly , then try to delete it.

I haven't tested it, but it might work.

 

[Ron de Bruin]

Hi Todd

I use it in my mail examples
Look at the code
http://www.rondebruin.nl/sendmail.htm#Sheet