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