rename and delete file in vba for Excel

[sal21]

2 siple question

... i want to rename file present in c:\test.txt in test01.txt
... i want to delete c:\test.txt

how make this in vba for Excel?

Please a simple macro

 

[Cbrine]

Kill path & Filename
Name path & filename as New Path & filename

Not sure about the Name command syntax, check the online help.

 

[TommyGun]

No need to delete it, just rename it...

<font face=Courier New><SPAN style="color:#00007F">Sub</SPAN> CopyAndDelete()
    Name "C:\Test.txt" <SPAN style="color:#00007F">As</SPAN> "C:\Test01.txt"
<SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN>
</FONT>

 

[fhyltavz]

Hi ! can you give me. english version of excel descrebe below. tahanks

for renaming picture files (works slow, unfort., but you can see the pictures)