Kill Function will not delete the file

[lnagel]

Looks fairly simple - Code runs just like it knows what to do and then nothing

File resides on Desktop and .Fullname does return the correct path

tempFileName = targetWorkbook.FullName
    'MsgBox "Target Workbook Name = " & tempFileName
    targetWorkbook.Save
    targetWorkbook.Close
    Kill tempFileName

I have also tried to close the workbook using the workbooks.close method - same results

Ideas?

 

[RoryA]

Do you get an error, or does it just do nothing?

As an aside, why save it if you're going to delete it?

 

[lnagel]

Dont get any errors UNLESS I omit the save (go figure)...........

 

[RoryA]

What error do you get if you omit the save?

 

[lnagel]

ooops Not correct - I get errors if I omit the close... I have tried both with and without the save.... both ways produce the same result (Nothing). However I get the Save Dialog Box if I dont do the save in the code

 

[RoryA]

If you don't get errors, it should be deleting something, assuming you haven't got On Error Resume Next shoved in there somewhere.

Try this:

tempFileName = targetWorkbook.FullName
    'MsgBox "Target Workbook Name = " & tempFileName
    targetWorkbook.Close False
    doevents
    Kill tempFileName

 

[lnagel]

so sent the workbook to work this morning - getting the same results on a different PC and Excel version... Don't have any On Error Resume Next in the code... Have also tried to do a Dlete via the FSO route - Same result doesnt work... I'm stumped

 

[RoryA]

Targetworkbook isn’t the workbook with the code in it, I assume?

 

[lnagel]

Hmmm.... so I have stumbled across a few threads where they were trying to create self kill routines . Having said that... I am trying to kill a copy of the workbook that I am running the code from that has been named something different.

So I end manipulating 3 different workbooks with one of those being a copy of the calling workbook.

You may have hit on the problem...

I will look at code in the morning to verify that what I think is running is actually running.

Great stab at this... the more I think iabout it..... the more likely it seems that you may be right.

 

[RoryA]

Add a Msgbox statement after the line that closes the workbook and see if you see the message.