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

  • Thread starter Thread starter Harry Fröhlich
  • Start date Start date
H

Harry Fröhlich

Hi everybody!

Dave suggested I post my request here. The post is also at:
http://www.ozgrid.com/forum/showthread.php?t=23831&goto=newpost

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.ozgrid.com
Excel Templates, Training, Add-ins & Software!
http://www.ozgrid.com/Services/excel-software-categories.htm **
 
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!
 
Back
Top