Hello all

well, what started out as a little project has turned into a major one.

i work in a department of a company where we have technicians who need to
send in a time card that records hours that they are doing service outside of
the manufacturing and production shop that they work in when not doing
service. up to this time we have had at least one problem every week that
time cards are submitted with either the actual information in the time card,
or who it is submitted to or the file name not conforming to the way we want
it submitted.

so i have been working on automating the submission of time cards. i have
everything working exactly the way i want it. when the workbook opens all the
toolbars are removed, a dialog pops up and asks for thier name, employee
number, and the date of the sunday at the beginning of the week they are
submitting for. i even used combo boxes for the date entry.

then i have a button which saves the file into a specific folder in the
users my documents, that folder is created if it isnt there, then it creates
an email with the workbook as an attachment and emails it to a specific email
address, adds the toolbars back, and finally closes excel and the workbook.
it is a pretty piece of automation if i do say so myself. :)

except that when i tried to send it from home to myself at work, to test
whether it will work from outside the office, it failed.

"Your message was rejected by (our server) for the following reason:
MS-Office file containing VBA macros found inside of the email The following
recipients did not receive this message: We hope this information is helpful."

ARRGH! so my first thought is to save the workbook, then save it again
stripped of all VBA as a separate file, then to email the stripped file, then
to delete the stripped file and then finish as before. is that the best
solution?

i was also thinking of having the code not put an extention on the file,
email it and then i can correct the extention when i recieve it. is that
going to work?

another thought is, would the system i have set up work as an add in that
causes a workbook to be sent that doesnt have VBA in it?

as i have worked on this, i have written it in other places. i need this to
be as dummy proof as possible. any suggestions or ideas or code posted would
be greatly appreciated.