macro to print then delete file completely

[excellentexcel]

hi guys i have a macro that works well
after i have pressed the print button i would like it to delete the file completely is this possible rather than manually doing it?
kind regards

[stanleydgromjr]

excellentexcel,

This should get you started in the right direction.

Programming The VBA Editor - Created by Chip Pearson at Pearson Software Consulting LLC
This page describes how to write code that modifies or reads other VBA code.
http://www.cpearson.com/Excel/vbe.aspx


Have a great day,
Stan

[excellentexcel]

cant quite see where i should be looking
i was hoping to press the print macro button and upon closing get vba to delete the file completely and send it to the recycle bin.

[stanleydgromjr]

excellentexcel,

Please TEST this FIRST in a COPY of your workbook (always make a backup copy before trying new code, you never know what you might lose).

Tom Urtis

Please Login or Register  to view this content.

Yes you can delete an open file or ThisWorkbook active file, and here is how.
One friendly piece of advice, make damn sure you save a copy of your victim workbook beforehand, in case you change your mind after the suicide code is executed.


Have a great day,
Stan