Removing Internet History and temporary files using vba

[sunnytahir]

Dear Sirs,

How can i clean internet history or temporary files using
vba in excel.

Thanks in advance for your kind help in this matter.

Best regards.

Tahir

 

[Rofeu]

Hi,

I assume that these files are all in one folder.

You might want to use the FileSearch approach to identify the files and then use the following loop:

[For I = 1 To .FoundFiles.Count]
[Kill .FoundFiles(I)]
[Next I]

You can check the Excel Help for the different FileSearch properties & methods.

I use a similar approach to clear my cache.

Hope this helps.

Cheers,

Roel