How to add a line of VBA script to delete file?

**EvelynLoh** · 11-02-2017, 04:14 AM

Dear All Expert in forum
Have manage to list out the files after select a folder. However, if I will like to click a hyperlink and delete the file from Excel.
May I know how can I add in the line?

Thank you so much for any help. Will definitely choose "Solved" and click "Reputable" for anyone who help me solve this headache.

**Kaper** · 11-02-2017, 05:00 AM

change to

Please Login or Register  to view this content.

and in your worksheet code (where Private Sub btnBrowse_Click() and other procedures reside) add:

Please Login or Register  to view this content.

PS. Why again without attachment ?
Just by chance I remembered also your previous thread and used it as a reference here, but how about those who had no chance to participate in previous thread?

**EvelynLoh** · 11-02-2017, 10:08 PM

Hi Kaper,

Thank you so much for your help again. I try change the code but it just open and not delete. Any idea how to call the WorkSheet_FollowHyperlink sub routine?

Thank you so much..

**EvelynLoh** · 11-03-2017, 06:13 AM

Hi Kaper,

Any update please on above question as just abit more... Please help me.

Thank you very much and hope to hear from you soon.

**Kaper** · 11-04-2017, 02:43 AM

Originally Posted by EvelynLoh

Any idea how to call the WorkSheet_FollowHyperlink sub routine?

This is Event handler for clicking hyperlink.

So to call it - just click on hyperlink.

This is how I interpreted what you asked in thread-opening post: "if I will like to click a hyperlink and delete the file from Excel."

**EvelynLoh** · 11-04-2017, 09:30 PM

Thank you so much for your reply Kaper. But when I click on the link, it open the file instead of delete. Any idea how do I attach the sub routine to the hyperlink?

Sorry for the question... Thank you very much.

**Kaper** · 11-05-2017, 02:44 AM

Not instead, but it does both: opens and deletes.

As I dont know how to cancel opening in this procedure, so may be another idea:
delete followHyperlink code from worksheet code and add:

Please Login or Register  to view this content.

And in TextToDisplay for column I use not Click Here to Delete but:

Please Login or Register  to view this content.

**EvelynLoh** · 11-06-2017, 03:52 AM

Hi Kaper,

Thank you so much for your help. It really works now. Appreciate your help.

Thank you for save my life...

**Kaper** · 11-06-2017, 04:02 AM

Saving life is for sure exaggerated

But I'm glad I could help
And thanks for marking thread solved and for reputation point

**EvelynLoh** · 12-15-2017, 05:29 AM

Hi Kaper,

Sad to say, this function still not solve..

We notice that some of the file can't be deleted. Not sure why though.. It just say "File not found" though the file is there.
Any idea why?? Stress up again as only this function is not working properly. Do you think is due to the script is wrong somewhere else why it says files not found but when click to open, can view but can't delete.

Please Login or Register  to view this content.

For the code that can click to open file .. it is stated below.

Please Login or Register  to view this content.

PLEASE HELP ME!!.... beg beg.. Thank you.

**bakerman2** · 12-15-2017, 05:58 AM

Does the hyperlink of the files that can't be deleted have fullpath in it's address ?
eg D:\whateverfile

**bakerman2** · 12-15-2017, 07:39 AM

Suddenly solved ??????

**EvelynLoh** · 12-15-2017, 09:33 AM

Yes else it can't even open.. the path is there..
Now the problem is it can open to see but can't delete when right click.. as it says files not found..

**EvelynLoh** · 12-15-2017, 09:33 AM

Not solve yet..;( pls advise ...thk u

**bakerman2** · 12-15-2017, 08:36 PM

Kill doesn't delete read-only files. Is this the case ?
If so you need to change the attribute using SetAttr.

**Kaper** · 12-16-2017, 04:24 AM

You could try it this way - also other attributes are tested (but I agree with bakerman2 that read-only is quite probable)

Please Login or Register  to view this content.

**EvelynLoh** · 12-17-2017, 08:13 PM

Hi...

But some is shortcut also can't be deleted... Any idea how to change the attribute?

Really head big big now... thank you so much.

**EvelynLoh** · 12-18-2017, 01:43 AM

Hi Kaper and bakerman,

After deep investigation, just realise that is due to the path of the sign is change for backslash to Yen sign.

Any idea how to tell Excel to change all Yen sign to back slash so can delete the file successfully?

Thank you so much.

**EvelynLoh** · 12-19-2017, 03:00 AM

Thank you very much...

**bakerman2** · 12-19-2017, 03:39 AM

Maybe you can try this.

Please Login or Register  to view this content.

**EvelynLoh** · 12-19-2017, 10:40 PM

Thank you bakerman2

Sadly still doesn't work as first time can delete but after I close the file and open and try to delete again. It says file not found again.

Any idea how to resolve the hyperlink issue so can find the file to delete?

Thank you soo much guys for your advise.

**EvelynLoh** · 12-20-2017, 04:42 AM

Any help please.........

**bakerman2** · 12-20-2017, 09:56 AM

Sadly still doesn't work as first time can delete but after I close the file and open and try to delete again. It says file not found again.

In one of your codes the row with the link is also removed after deleting the file so how can you try again to delete ???????

**EvelynLoh** · 12-20-2017, 09:49 PM

Hi bakerman

Sorry you mean below code? As I need to delete the row also else is confuse if the file is no longer there but row still shows.
Sorry as have limited knowledge on Excel. How can I change the code so that can delete successfully everytime when goes in?
Thank you very much.

**bakerman2** · 12-20-2017, 11:34 PM

Yes, otherwise link remains to none existing file.

**EvelynLoh** · 12-21-2017, 01:02 AM

Thank you bakerman,

May I know is there any way to delete the file successfully as well as remove the row in Excel after file deleted instantly?

How should I improve the script? Hope to hear from you soon.

Thank you.

**bakerman2** · 12-21-2017, 01:52 AM

Your code in post#24 does that.

**EvelynLoh** · 12-21-2017, 02:14 AM

Hi Bakerman2

Yes am aware... But how should I able to kill the file without using Explorer if don't use this formula?

Also, please advise how can I improve the script so that can delete file upon right click and also delete the row away without remove all the file's hyperlink?

Please advise?

Thank you.

**bakerman2** · 12-21-2017, 02:42 AM

In post#8 you say this works but some files can't be deleted due to path.
So after amendement regarding path this should work also.

Please Login or Register  to view this content.

If this doesn't work for you then I have absolutely no idea anymore of what it is you're after.
This thread has become so confusing I just can't tell anymore what is what.

**EvelynLoh** · 12-22-2017, 03:45 AM

Hi Bakerman2

I have use exact same script you stated here but as usual, once I download the file, I can delete any files successfully. But once I save the Form, close and open again.. I can't delete anymore. It just stated "File not Found"... :-(

**EvelynLoh** · 12-22-2017, 04:52 AM

Hi Bakerman2,
I really appreciate your help too..

Thank you very much..

**EvelynLoh** · 12-25-2017, 08:31 PM

Hi Kaper

Can you please help me on my bug on why it can't be deleted pls?

How to add a line of VBA script to delete file?

Re: How to add a line of VBA script to delete file?

Re: How to add a line of VBA script to delete file?

Re: How to add a line of VBA script to delete file?

Re: How to add a line of VBA script to delete file?

Re: How to add a line of VBA script to delete file?

Re: How to add a line of VBA script to delete file?

Re: How to add a line of VBA script to delete file?

Re: How to add a line of VBA script to delete file?

Re: How to add a line of VBA script to delete file?

Re: How to add a line of VBA script to delete file?

Re: How to add a line of VBA script to delete file?

Re: How to add a line of VBA script to delete file?

Re: How to add a line of VBA script to delete file?

Re: How to add a line of VBA script to delete file?

Re: How to add a line of VBA script to delete file?

Re: How to add a line of VBA script to delete file?

Re: How to add a line of VBA script to delete file?

Re: How to add a line of VBA script to delete file?

Re: How to add a line of VBA script to delete file?

Re: How to add a line of VBA script to delete file?

Re: How to add a line of VBA script to delete file?

Re: How to add a line of VBA script to delete file?

Re: How to add a line of VBA script to delete file?

Re: How to add a line of VBA script to delete file?

Re: How to add a line of VBA script to delete file?

Re: How to add a line of VBA script to delete file?

Re: How to add a line of VBA script to delete file?

Re: How to add a line of VBA script to delete file?

Re: How to add a line of VBA script to delete file?

Re: How to add a line of VBA script to delete file?

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Script to save to folder in "v:\dept2", confirm file saved, then delete from "v:\dept1"

[SOLVED] command line Excel Script

Bookmarks

Bookmarks

Posting Permissions