+ Reply to Thread
Results 1 to 7 of 7

email any changes in excel

  1. #1
    Registered User
    Join Date
    03-12-2008
    Posts
    14

    email any changes in excel

    Hello all,
    If this is the wrong place for this question or has been addressed already please point me in the right direction.

    Is it possible to email me any time someone makes changes to an excel file. Don't want anything special in the email just a notification of real time changes (as soon as the change is made)?

    Thanks in advance.

  2. #2
    Forum Expert Domski's Avatar
    Join Date
    12-14-2009
    Location
    A galaxy far, far away
    MS-Off Ver
    Darth Office 2010
    Posts
    3,950

    Re: email any changes in excel, possible?

    Possible yes. You can use a Workbook level SheetChange event to detect if someone changes anything. It would be the sending of the email itself that could cause problems as Outlook and a lot of virus software will detect if an email is being sent automatically and try and block it.

    You might want to look here for more info: http://www.rondebruin.nl/sendmail.htm

    Dom
    "May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."

    Use code tags when posting your VBA code: [code] Your code here [/code]

    Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.

  3. #3
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: email any changes in excel, possible?

    Hello su_jumptd,

    As a follow up to Domski's suggestion, instead of Outlook the email could be sent using CDO. This will avoid the security messages. The big disadvantage of this is if you need to log onto your email. CDO would require your email account and password, which would be visible to anyone viewing the code. You could of course password protect your VBA project and prevent the user from viewing the code. However, this is not completely secure as the VBA project password can be broken rather easily.

    Sending mail from Excel with CDO
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  4. #4
    Forum Expert Domski's Avatar
    Join Date
    12-14-2009
    Location
    A galaxy far, far away
    MS-Off Ver
    Darth Office 2010
    Posts
    3,950

    Re: email any changes in excel, possible?

    Quote Originally Posted by Leith Ross View Post
    Hello su_jumptd,

    As a follow up to Domski's suggestion, instead of Outlook the email could be sent using CDO. This will avoid the security messages. The big disadvantage of this is if you need to log onto your email. CDO would require your email account and password, which would be visible to anyone viewing the code. You could of course password protect your VBA project and prevent the user from viewing the code. However, this is not completely secure as the VBA project password can be broken rather easily.

    Sending mail from Excel with CDO
    I have used CDO but McAfee blocks it where I work so it's not foolproof. To get round the Outlook issue I've used MAPILab's Advanced Security for Outlook but this would need installing and configuring on each machine.

    Dom

  5. #5
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: email any changes in excel, possible?

    Hello Dom,

    Thanks for pointing that out. I have my firewall configured to allow CDO to work on my machine. However, mine is a personal firewall and not a company one. If your company has a firewall and your not sure if would be a problem, talk with your IT department first to see if it is allowed.

  6. #6
    Registered User
    Join Date
    03-12-2008
    Posts
    14

    Re: email any changes in excel, possible?

    Oh, dang.....
    Wow, seems complicated. I would have thought it would be a little less difficult. No biggy, I like to track changes as soon as they are done but it's not a very high priority.

    Thanks for all the input.

  7. #7
    Forum Contributor
    Join Date
    07-13-2007
    Posts
    151

    Re: email any changes in excel, possible?

    Leith,

    As an aside...

    I agree with you that VBA projects passwords are easy to crack in Excel 2003 and earlier. I notice in your profile that you might not be using 2007. The methods I'm aware of for getting to the Excel 2003 VBA Project passwords don't work for 2007 as the encryption has been significantly modified.

    Any opinions on VBA Project passwords in Excel 2007 and the security they might provide?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1