Finding and Deleting attachment via VBA when attachment (*.xls) is opened

Finding and Deleting attachment via VBA when attachment (*.xls) is opened

Post by Harry Frli » Wed, 15 Sep 2004 15:55:24


Hi everybody!

Dave suggested I post my request here. The post is also at:
http://www.yqcomputer.com/

Some time ago, during last year, I had a post like this. It was
partially answered, but I then stopped it because, mainly, it bordered
on creating a virus, someone thought.

I am, however, seriously considering distributing workbooks via the
e-mail system and want to

1) prevent clientA from forwarding it to non-paying clientB (I may make
use of ReadNotify.com's feature that prevents this (From what I read!)).

2) I also want to prevent clientA from being able to copy the file to a
distributable medium such as a CD (in other words, onto a drive with
another character (C to D)) BEFORE it has been opened. After it has been
opened, Registry entries will be imprinted in the file, rendering it
useless on other machines even if is saved for personal use. (For those
of my abilities, that is!!)

Deleting the attachment, in the end, may be circumvented by the above,
but any views on this will be welcomed. I may still need the attachment
and/or e-mail deleted upon first opening of the attachment (Excel file)
and the VBA code that does this then stopped once the deletion is
confirmed. BTW, "Delete" should read "Kill" - kept out of any Deleted
Folder / Recycle Bin.

Is it possible to do either (both, preferably!) of the requests 1) an 2)
above, please?

Kindest possible regards

Harry


** Posted via: http://www.yqcomputer.com/
Excel Templates, Training, Add-ins & Software!
http://www.yqcomputer.com/ **
 
 
 

Finding and Deleting attachment via VBA when attachment (*.xls) is opened

Post by Frank Kabe » Wed, 15 Sep 2004 16:37:49

Hi
this is iMHO either not possible or really would require
to write a kind of virus.
- You can't control from an email where the user wants to
store the attachment.
- you can't prevent forwarding
- Also this kind of deletion is not allowed

To be honest If I would receive such a program and you
would be able to do this and accidentically delete other
valid files you'll have fun with my lawyer :-))

This is not the right way to distribute applications. If
you need security Excel is NOT the right application to
write secure programs.
you could create a COM-addin which is more secure but
don't try to mess with the email system of the recipient!


at:
t=23831&goto=newpost
It was
mainly, it bordered
workbooks via the
clientB (I may make
what I read!)).
the file to a
drive with
After it has been
rendering it
use. (For those
by the above,
the attachment
attachment (Excel file)
deletion is
any Deleted
requests 1) an 2)
categories.htm **

 
 
 

Finding and Deleting attachment via VBA when attachment (*.xls) is opened

Post by Harry Frli » Wed, 15 Sep 2004 20:21:29

Thanks Frank

I truly did not expect it to be such a NO-NO, but am willing to
graciously accept all the kind advice and probability that this is
something I should let go of.

Consider this topic dead and buried.

Kindest possible regards

Harry

** Posted via: http://www.yqcomputer.com/
Excel Templates, Training, Add-ins & Software!
http://www.yqcomputer.com/ **