I wrote the following code to prevent the email containing "@lifebloodsd.org" in the address of the person attempting to attach the excel workbook from a folder in a server. However, it does not work. How could this be rewritten differently so that it will work?
Please Login or Register to view this content.
This code does not remotely match what your post describes.
The code prevents a user from saving this Excel file if the title bar contains "lifebloodsd" which would happen only if that string is part of the Excel file name.
There is no way to write code in an Excel file to prevent a person from attaching that Excel file to an email. When attaching a file to an email, the file is not opened and if it has code the code does not run.
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
Thanks for explaining that. Did not realize attachments are not opened first when linked to an email address.
Not sure what you mean by "linked to an email address". Here is the process in some detail.
You Create New email. Your email client creates an object that is the email, and presents it to you for editing.
You click Attach a file. You navigate to the file and click OK.
The email client makes a copy of that file and inserts it into the email. (This is done by encoding the file into ASCII characters but I'm not going to get into the details.)
You click Send and the email is sent.
The file is never opened during this process. It's similar to copying a file from one place to another on your computer. The file never has to be opened to do that.
Yes, that does make sense. I see that the word "linked" is the wrong term to use in this case.
So, a file essentially is incapable of doing anything unless it is opened. I had hoped file could be made to tell a certain email address to bug off when it tries to make copies of it. Something else will be needed to come in and shield off the email address from copying.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks