Hello Alan

actually i dont want to send a time sheet with code in it. i want to send a
spreadsheet through my companies email server. the problem is that our
firewall was not set up properly. at this time it is working beautifully. i
have a template that the users will have, they will open the workbook and
then it will help them in entering the required information, and when they
press the button i have on the sheet it will email a copy of itself to the
appropriate email and save itself to the appropriate directory on thier
laptop.

i had been explaining what i was trying to do to our IT staff and the other
day the boss was complaining about the fact that he had to use an AOL account
to get email from certain customers. when the boss is working around the
companies own mail server you know there is a problem. the IT staff looked at
the situation and everything has been resolved, including my spreadsheet
problem. WOO HOO!

so thanks for the suggestion, but at this time i am happy with what i have.
thanks to all who helped me with this, in this and other threads. :)

"Alan" wrote:

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.