Send Time Stamp by email

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rodrigo - 17 Mar 2008 21:35 GMT

Is their a way to send a spreedsheet with a macro rule trought email. The one
i am cunsorne with is the time stamp macro, provided by McGimpsey in the link
below. I figured out how to use it but know i am trying to send it to some
customers but the formula does not work. The formula is still in the code
tab, but i guess it does not work.

Any suggestions.

http://www.mcgimpsey.com/excel/timestamp.html

Reply to this Message

Tyro - 17 Mar 2008 21:45 GMT

"Code tab" What is that?

Tryo

> Is their a way to send a spreedsheet with a macro rule trought email. The
> one
[quoted text clipped - 7 lines]
>
> http://www.mcgimpsey.com/excel/timestamp.html

Reply to this Message

Gord Dibben - 17 Mar 2008 23:47 GMT

Which of the two of John's methods did you use?

If the worksheet_change event code, did you paste the code into a worksheet
module as instructed?

Did you test to see if it worked?

Did you save the workbook after testing OK?

If the macro on a button code, did you paste the code into a general module?

How are you calling the macro?

Did you test to see if it worked?

Are the recipents enabling macros when they open your workbook?

Gord Dibben MS Excel MVP

>Is their a way to send a spreedsheet with a macro rule trought email. The one
>i am cunsorne with is the time stamp macro, provided by McGimpsey in the link
[quoted text clipped - 5 lines]
>
>http://www.mcgimpsey.com/excel/timestamp.html

Reply to this Message