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?

 

[Keebellah]

The file must be closed to be able to 'kill' it

 

[lnagel]

Spot ON! - I had a "SaveAs" that needed to be a "SaveCopyAs".... One of those couldnt see the forest cuz of the trees conundrums. Thanks so much RoryA