VBA for Email and Modification date/user

**iamreese** · 11-08-2011, 10:49 AM

Hi..I am quite a newbie when it comes to VBA..

I have this project that every time I made changes to my excel file, the following will happen:

1. Send an auto email (I am using outlook) with notifications of changes.
2. Will create a log in a separate sheet on who last modified and time modified.

I found 2 scripts but I am facing some problem because both are using "Workbook_BeforeSave"

Below are the codes I intend to use:

FIRST CODE:

Please Login or Register  to view this content.

SECOND CODE:

Please Login or Register  to view this content.

How do I combine these 2 scripts in one?

**Domski** · 11-08-2011, 10:55 AM

Hi,

Please take a moment to read the forum rules and add code tags to your post.

Dom

**iamreese** · 11-08-2011, 11:05 AM

^^^opps I'm bad..sorry about that..anyway I edited my first post..thanks again for the reminder..

**Domski** · 11-08-2011, 11:13 AM

One is using a Before_Save event and the other an Open event so don't actually need to be combined. If you wanted to though it would just be like this:

Please Login or Register  to view this content.

Dom

**iamreese** · 11-08-2011, 11:29 AM

Thanks for that quick reply and it actually worked but I need to know who modified it:

what if I use the second script below to combine to the first script (email). How do I make them as one?

Please Login or Register  to view this content.

Please Login or Register  to view this content.

**Domski** · 11-08-2011, 11:53 AM

The second script you've quoted now logs every change that anyone makes to any cell on a sheet. I'm sure you don't want an email each time that happens. If you just want the ID, date and time of the person saving the document:

Please Login or Register  to view this content.

Dom

**iamreese** · 11-08-2011, 12:10 PM

Thanks a lot Domskie..just what I need!

**iamreese** · 11-08-2011, 12:14 PM

MY query is solved! Thanks a bunch and more power on this forum

**iamreese** · 11-09-2011, 05:14 AM

Just a followup question..

For the email notification, is it possible to be an optional for the user to send an email? and not automatic..although this is a least of my concern but just happened to cross my mind

**Domski** · 11-09-2011, 05:37 AM

Sure:

Please Login or Register  to view this content.

I've updated the code a bit too.

Dom

**iamreese** · 11-09-2011, 06:04 AM

and that was super fast...Thanks a lot Dom for your continued assistance. I really appreciate it!

**iamreese** · 11-09-2011, 07:21 AM

Dom, with your code above, i want to combine the auto uppercase command using this code on specific column (column B to column CN)

Please Login or Register  to view this content.

**Domski** · 11-09-2011, 08:01 AM

That's a worksheet level event code so should go on the relevent sheet's code page.

Just set the column to change here:

Please Login or Register  to view this content.

Dom

**iamreese** · 11-09-2011, 08:16 AM

Domski I am learning a lot from you. As always, thanks!

VBA for Email and Modification date/user

LinkBack

Thread Tools

Rate This Thread

Display

VBA for Email and Modification date/user

Re: VBA for Email and Modification date/user

Re: VBA for Email and Modification date/user

Re: VBA for Email and Modification date/user

Re: VBA for Email and Modification date/user

Re: VBA for Email and Modification date/user

Re: VBA for Email and Modification date/user

[SOLVED] VBA for Email and Modification date/user

Re: VBA for Email and Modification date/user

Re: VBA for Email and Modification date/user

Re: VBA for Email and Modification date/user

Re: VBA for Email and Modification date/user

Re: VBA for Email and Modification date/user

Re: VBA for Email and Modification date/user

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions