Hi Dawn,

I just noticed this thread and became curious. I am curious why the time
sheet e-mailed to you would need any code in it at all. Wouldn't it be easy
to structure your code around sending and receiving a time sheet with no VBA
included? On the user computer, the install the code necessary to do what
ever you want to do on their end to compile/send a simple time sheet. On
your computer, install the code necessary to do what ever you need it to do
to extract the information from a simple time sheet.

I am a firm believer in keeping all code out of a worbook that may be passed
on to other users. (I'm speaking with my company mentality goin' on.)
Multiple copies multiply to the nth degree causing storage costs to rise. I
see no reason for the need to send a workbook with VBA in it to pass any
data. I know, if there is data in a cell, I can extract it, so why do I need
code in the workbook?

If you do not have access to all the user computers, and need them to have a
module installed, send them a notepad file of your modules, with
installation instructions, & talk them through the install over the phone. I
have done this hundreds of times and it doesn't takes more than 10 minutes
with the dimmest lights.

This is 100% guaranteed to pass any e-mail server worldwide.

Regards,

Alan


"DawnTreader" wrote in message
...
Hello

" wrote:
It sounds to me like you're a virus writer and you're trying to
obfuscate mailicous VB code.

no i am not. i guess this just wont work. i am really tired of microsoft
screwing up the abilities of thier programs. it is amazing to me how
complicated and how many roadblocks i found trying to simply email a
spreadsheet.

i thought i had found a way to make things easy for my technicians to
input
and send me a copy of thier timesheet. but now it seems that i need to
write
my own program outside of excell to make this work.

what is microsoft thinking? i understand the need for security, but there
has to be some way to make this work.

thanks for the suggestion about the vb script. but that wont work. i have
spent more time than i should have on this project. i need an elegant
solution to this problem, something so simple that it wont take much more
vba
programming, and will get around the filters in any email system.

any ideas or suggestions would be appreciated.