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

[jwlamb]

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

[chinraj]

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.

[jwlamb]

use "gpedit.msc" instead of window scheduler

Thank you, but I already tried that, access denied.