I have a macro which has copied data from a workbook, I now want the macro
to delete the entire workbook (send it to the recycle bin) but can't figure
out how to do it. Can someone please help me with this problem.

KILL "path"

"Ed" <(E-Mail Removed)> wrote in message
news:vFOXl.33431$(E-Mail Removed)...
> I have a macro which has copied data from a workbook, I now want the macro
> to delete the entire workbook (send it to the recycle bin) but can't
> figure out how to do it. Can someone please help me with this problem.
>

Just so the OP knows, Kill doesn't send the file to the Recycle Bin (as the
OP indicated he wanted)... it permanently removes the file from the drive.

--
Rick (MVP - Excel)


"Patrick Molloy" <(E-Mail Removed)> wrote in message
news:CCB3F6F0-FC10-4D09-BB71-(E-Mail Removed)...
> KILL "path"
>
> "Ed" <(E-Mail Removed)> wrote in message
> news:vFOXl.33431$(E-Mail Removed)...
>> I have a macro which has copied data from a workbook, I now want the
>> macro to delete the entire workbook (send it to the recycle bin) but
>> can't figure out how to do it. Can someone please help me with this
>> problem.
>>

If the OP wants to use the Recycle Bin, there is an API solution to do so.
There is an example of how to do this here...

http://vbnet.mvps.org/code/shell/recyclebin.htm

If the OP needs help breaking this apart for his own needs, he should post
back to this thread and someone here will assist him.

--
Rick (MVP - Excel)


"Rick Rothstein" <(E-Mail Removed)> wrote in message
news:%23$(E-Mail Removed)...
> Just so the OP knows, Kill doesn't send the file to the Recycle Bin (as
> the OP indicated he wanted)... it permanently removes the file from the
> drive.
>
> --
> Rick (MVP - Excel)
>
>
> "Patrick Molloy" <(E-Mail Removed)> wrote in message
> news:CCB3F6F0-FC10-4D09-BB71-(E-Mail Removed)...
>> KILL "path"
>>
>> "Ed" <(E-Mail Removed)> wrote in message
>> news:vFOXl.33431$(E-Mail Removed)...
>>> I have a macro which has copied data from a workbook, I now want the
>>> macro to delete the entire workbook (send it to the recycle bin) but
>>> can't figure out how to do it. Can someone please help me with this
>>> problem.
>>>
>

Thanks Patrick, it works great.


"Patrick Molloy" <(E-Mail Removed)> wrote in message
news:CCB3F6F0-FC10-4D09-BB71-(E-Mail Removed)...
> KILL "path"
>
> "Ed" <(E-Mail Removed)> wrote in message
> news:vFOXl.33431$(E-Mail Removed)...
>> I have a macro which has copied data from a workbook, I now want the
>> macro to delete the entire workbook (send it to the recycle bin) but
>> can't figure out how to do it. Can someone please help me with this
>> problem.
>>

Thanks Guys - I don't really care what happens to the file. Appreciate all
your help - working fine.


"Rick Rothstein" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> If the OP wants to use the Recycle Bin, there is an API solution to do so.
> There is an example of how to do this here...
>
> http://vbnet.mvps.org/code/shell/recyclebin.htm
>
> If the OP needs help breaking this apart for his own needs, he should post
> back to this thread and someone here will assist him.
>
> --
> Rick (MVP - Excel)
>
>
> "Rick Rothstein" <(E-Mail Removed)> wrote in message
> news:%23$(E-Mail Removed)...
>> Just so the OP knows, Kill doesn't send the file to the Recycle Bin (as
>> the OP indicated he wanted)... it permanently removes the file from the
>> drive.
>>
>> --
>> Rick (MVP - Excel)
>>
>>
>> "Patrick Molloy" <(E-Mail Removed)> wrote in message
>> news:CCB3F6F0-FC10-4D09-BB71-(E-Mail Removed)...
>>> KILL "path"
>>>
>>> "Ed" <(E-Mail Removed)> wrote in message
>>> news:vFOXl.33431$(E-Mail Removed)...
>>>> I have a macro which has copied data from a workbook, I now want the
>>>> macro to delete the entire workbook (send it to the recycle bin) but
>>>> can't figure out how to do it. Can someone please help me with this
>>>> problem.
>>>>
>>
>