VBA to run auto email code when date becomes yesterday

Hi guys,

I'm pretty new to VBA, however all is well so far - i need to see if anyone can help?

In short i have the code to convert my workbook to pdf and auto email however what i'm struggling with is finding "todays" date code to initalize that function, a true neewbie question i guess although I've had a look around on the forums with no joy as yet of course by the title i want this to run at either 00:00:01 always or today -1

The workbook will be always open...

Any help would be much appreciated!

cheers

The function you want is just ' = Date'. You can't run at = today-1, as that condition can never be true by reference to today's date. I think it's safer to just require it to run at 00:01:00.

The main problem I fear you will encompass however is that outlook will require you to alow a macro to send an email, and it will require this every time. You may be able to avoid this by setting the security on Outlook to low, but this isn't always a feasible method to follow, particularly on a work computer.

Thanks for your reply, i now have this working using applicationontime and VB Day for weekly monthly is also working using date value...on the outlook front it will be on a work machine but the outlook account on that machine will always be open..i've been testing on a work machine using the work accounts and all is well