Hi ,
I am trying to send this file daily at 10am using the wonderful code and 'OnTime' by Ron De bruin however it is not working. the Code runs when I run the macro manually but not automatically.
anything I am doing wrong.??
see attached..
So I tried using the Private Sub Workbook_Open() to call the Macro and then using the windows scheduled tasks to open the workbook at the specified time.
However here is the glitch. I only want the file to be sent at a particular time and not every time I open the sheet as this needs to be modified by multiple users.(its on a Shared drive). and I want it to run on weekends when I am not at the desk.
how do I get this to work??
Bookmarks