delete the file by vba

[Leonardo1234]

file that i have to delete is located in C:\Users\user\Desktop\Stock Market\Sholtan\1.xlsm
macro will be placed in C:\Users\user\Desktop\Stock Market\Sholtan\2a.xlsb

 

[shrivallabha]

Then it is A Time To (use) Kill

https://msdn.microsoft.com/en-us/vba/language-reference-vba/articles/kill-statement

 

[vletm]

Leonardo1234

Sub Delete_It()
    Kill "C:\Users\user\Desktop\Stock Market\Sholtan\1.xlsm"
End Sub

ps. remember backups and google

 

[Leonardo1234]

Thnx vletm & shrivallabha for giving ur precious time and great support to this post
Problem Solved

 

[Leonardo1234]

What if i have to delete two files at once

 

[shrivallabha]

It totally depends on how your system is!

If the name and path is specific (as in your question) then you can write two statements

kill file1

kill file2

 

[Belleke]

You can try this.
Place this file in the same folder as the one where you want to delete files.
Listbox will be filled with the excel files.
Select a file and delete, select next and delete and so on...

 

[Leonardo1234]

Thnx Belleke for giving ur precious time and great support to this post