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