+ Reply to Thread
Results 1 to 3 of 3

Run VBA on schedule when WB is closed and user is logged off

  1. #1
    Registered User
    Join Date
    08-14-2013
    Location
    Arizona
    MS-Off Ver
    Excel 2007
    Posts
    71

    Run VBA on schedule when WB is closed and user is logged off

    Good evening all, I've been tasked at work to make an excel file to do more than what I think I can figure out on my own. What I need done is this:

    1. Every Monday, check excel file for data
    2. If data exists, send email with said data

    Here's my issues:

    How do I get the workbook to open while logged off the computer? The file is stored on a share network drive, not locally.
    How do I get it to send an email without someone logged on to click "send"?

    I tried using windows scheduler, but I don't have sufficient privileges to run as batch (IT restrictions).

    PLEASE HELP!!

    Justin

  2. #2
    Registered User
    Join Date
    02-27-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    77

    Re: Run VBA on schedule when WB is closed and user is logged off

    use "gpedit.msc" instead of window scheduler

    Steps:
    1. Go to start button and click on 'Run'
    2. Paste the above term(without "") and press enter
    3. Group Policy will open, in that, under 'User Configuration -> click windows settings
    4. See right pane, there is scripts(logon/Logoff)
    5. From there, I think you know what to do further.

  3. #3
    Registered User
    Join Date
    08-14-2013
    Location
    Arizona
    MS-Off Ver
    Excel 2007
    Posts
    71

    Re: Run VBA on schedule when WB is closed and user is logged off

    Quote Originally Posted by chinraj View Post
    use "gpedit.msc" instead of window scheduler
    Thank you, but I already tried that, access denied.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. User name - currently logged on.
    By Caula in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-14-2012, 11:14 AM
  2. Call user form for logged in user's cell only
    By Spagbog in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-11-2011, 10:41 AM
  3. User that is logged in
    By Gunilla in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-05-2010, 01:14 PM
  4. Logged in User
    By mikesjd110 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-13-2009, 08:26 AM
  5. Find Out Logged in User
    By Nigel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-30-2005, 02:05 AM

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