Killing a file that is open

I am having nightmares with this issue so I was wondering if someone could suggest something.

Here is my macro:

Please Login or Register  to view this content.

Basically I have a spreadsheet linked to get live prices of a stock. Every time the stock price changes, I call this macro and it replaces the current file with a new file containing the stock price. I have another program in C# that is reading this file every time I click a button. I have had tons and tons of problems with deleting files that are currently in use so I added the ErrorHandler. This fixes the problem most of the time, but once in a while it still throws an error in the ErrorHandler.

What am I doing wrong?

Thanks for your help
-Jeff

Does this look better?

Please Login or Register  to view this content.

But doesn't the On Error GoTo 0 make it keep going through the function until it successfully deletes the file?

Ok I see. So I changed the deleteFile function to return whether or not it was successful, and then if it wasnt successful the first function quits. Does this sound better?

Thanks for all your help.

Please Login or Register  to view this content.