Deleting in excel

[Sirishgreen]

i have some code running to generate a hyperlink from each file in a folder (for easy navigation). I now want a way of deleting a file from the folder when its no longer needed. I would like a button to do this from inside excel.

any ideas?

[VBA Noob]

See if link helps

http://www.rondebruin.nl/folder.htm

VBA Noob

[Sirishgreen]

like the link, but not sure I can make what i need out of it.

Basically I want to delete a spreadsheet from inside another spreadsheet.

Any ideas?

[VBA Noob]

Not what you asked

way of deleting a file from the folder when its no longer needed

VBA Noob

[Sirishgreen]

well the spreadsheet is a file and its inside a folder :P so technically its the same thing. I have decided that i would rather open the folder and them delete it manually seems easier, and same difficulty as any other method for the user.

So any advice on how to open a folder in explorer from inside excel would be great thanks.

so yes i have changed my mind again....lol sorry