Delete Files Using VBA

Gambar 233.M3

VBA Delete Files Macro helps to Delete Files using VBA from a folder. 

Generally while dealing with the file operations we create or delete files using VBA in the process. 

For example when we are automating a specific task, we create lot of intermediate files and finally we produce one final output. At end we clean or delete all the intermediate files using VBA.

The MsgBox Function

You’re probably already familiar with the VBA MsgBox function — I use it quite a bit in the examples throughout this book. 

The MsgBox function, which accepts the arguments shown in Table 15-1, is handy for displaying information and getting simple user input. It’s able to get user input because it’s a function. 

A function, as you recall, returns a value. In the case of the Msgbox function, it uses a dialog box to get the value that it returns. Keep reading to see exactly how it works.

Here’s a simplified version of the syntax for the MsgBox function:

MsgBox(prompt[, buttons][, title])

You can use the MsgBox function in two ways: