Kill "C:\My Documents\MICR.xls""

HTH
--
AP

"nowfal" <nowfal.2560ny_1143189000.5679@excelforum-nospam.com> a écrit dans
le message de news:nowfal.2560ny_1143189000.5679@excelforum-nospam.com...
>
> Hi all,
> I have the following code
> Range("A5,A4").ClearContents
> Range("A4").Select
> Windows("MICR.xls").Activate
> Range("N2").Select
> Windows("MICR PRINT.xls").Activate
> ActiveCell.FormulaR1C1 = "=MICR.xls!R2C14"
> Range("B4").Select
> Sheets("DA").Select
> Range("A9,A10,A11").ClearContents
> Range("A10").Formula = "=Spellnumber(A9)"
> Range("A9").Select
> Windows("MICR PRINT.xls").Activate
> ActiveCell.FormulaR1C1 = "=MICR.xls!R2C15"
> Range("A2").Select
> Sheets("SA").Select
> Range("A9,A10,A11").ClearContents
> Range("A10").FormulaR1C1 = "=SPELLNUMBER(R[-1]C,""INR"")"
> Range("A9").Select
> Windows("MICR PRINT.xls").Activate
> ActiveCell.FormulaR1C1 = "=MICR.xls!R2C15"
> Range("A2").Select
> Sheets("MICRI").Select
> Range("A1").Select
> ActiveWorkbook.Save
> Windows("MICR.xls").Activate
> ActiveWorkbook.Close
>
> In this final 2 lines i wanted a change instead of
> ActiveWorkbook.close
> i wanted to delete the MICR.xls file which is in C:My Document, i tried
> Delete
> Any other alternate for this
> with regards
> nowfal
>
>
> --
> nowfal
> ------------------------------------------------------------------------
> nowfal's Profile:
http://www.excelforum.com/member.php...o&userid=10003
> View this thread: http://www.excelforum.com/showthread...hreadid=526010
>