Deleting file obtained from VBA shell to Batch file

Good morning plasma33

Use the Kill statement to permanently delete a file, thus :

Please Login or Register  to view this content.

As stated above this deletes the file, not removing it to the recycle bin, just in case.

If you want to move it to the recycle bin (just in case!), this gets a little trickier, as it's a Windows object.
Chip Pearson offers a solution to this here.

HTH

DominicB

Good Morning, DominicB,

thank you for your kind reply.

it worked perfectly fine..i tried using the kill function before but it didn't work before...anyways its working fine now..

i have a question regarding system refresh...do you know a vba code for a system refresh...something similar to F5 or a right click refresh type using vba macro...i tried looking on google but in vain...

thanks again.

best regards
plasma33

Hi plasma33

By "system" are you referring to Excel itself?
If so, your probably looking to recalculate everything.

In this case, there are a few options - you could use any of the three below, depending on what scope you're after.

Please Login or Register  to view this content.

As I said, any of the three will do - if you do a full rebuild, it's a waste of time and resources to do any of the others as well.

HTH

DominicB

Hi DominicB,

thanks for a prompt reply.

i meant by an actual system windows refresh. is there any way to do it. even an equivalent of a windows system refresh would do.

thanks again, DominicB

best regards
plasma33

Hi plasma33

You're going to have to explain what you mean by a system refresh. What is it that you are not seeing that you expect to see, or vice versa?

Unless you've been tinkering with the ScreenUpdating function, and not turned it back on (although this usually turns back on by default at the end of a routine).
Try this :

Please Login or Register  to view this content.

Otherwise you need to explain why you think a "system refresh" is necessary.

HTH

DominicB

Hi Dominic,

thank you for your reply.

i am actually unzipping some files and then performing some tasks and then kill some files.

but i have to refresh the desktop manually to get rid of the files. although the files are deleted but it needs a system refresh to get rid of the files. only happens for desktop though.

i have a code which is suppose to do it but for some reason it does it for folders and not for desktop

please find the code below:

Please Login or Register  to view this content.

thanks again.

best regards
plasma33