Amend Code - Hyperlink Delete

[Sirishgreen]

I have a button that populates a list box with a list of hyperlinks, which open the respective files. I now want the same layout but want to be able to delete the files using the hyperlinks in a list box and not open the file. here is the code behing the button.

Please Login or Register  to view this content.

i want to delete the hyperlinks destination.

thanks in advance,

Simon Green

[Leith Ross]

Hello Simon,

Do you want to clear the List Box entry or delete the actual file or both?

Thanks,
Leith Ross

[Sirishgreen]

Hi, Leith

I want to delete the file only. There is no need to delete the entry in the list box because it is populated by another list which is updated everytime the form loads. I think Closing the form after deletion would be suffice.

Thanks,

Simon Green

[Leith Ross]

Hello Simon,

This macro will permanently remove the file. If you want to delete the files by sending them to the Recycle Bin, let me know, and I'll give you the macro code to do it that way.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

[Sirishgreen]

Thanks Leith,

I have a problem though,

This line of code is in red

Please Login or Register  to view this content.

and says invalid syntax.

Cheers

Simon Green

[Leith Ross]

Hello Simon,

Sorry about that, my typing skills aren't what I would like them to be. Here is what the code should be...

Please Login or Register  to view this content.

Sincerely,
Leith Ross

[Sirishgreen]

silly little space.....LOL

thankyou works a treat, My project is getting closer to its finish now.

I really appreciate the help,

Simon Green