Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
emailing worksheet
I have been able to create the macro to email my workbook (thanks Jakab) now
I want to schedule the emailing macros once a day and still be able to open the workbook for updating throughtout the rest of the day . I tried the windows scheduler but it will email each time I open the workbook. What can I do to get what I want ...is it extra code in the macros or something I missed in the scheduler? Cheers |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
emailing worksheet
You are probably running Workbook_open event code in order for the email to
be sent when Task Scheduler starts Excel and opens the workbook. If you don't want the email sent every time you open the workbook you must revise the code. Maybe check for the time and if within a certain limit, cancel the email event. Else run your email code. Example................ If Time "3:00am" And Time < "4:00am" Then send email code runs Else cancel = true 'cancels the send email code" End If Adjust time window to suit. Gord Dibben MS Excel MVP On Sat, 1 May 2010 09:40:08 -0700, Norm wrote: I have been able to create the macro to email my workbook (thanks Jakab) now I want to schedule the emailing macros once a day and still be able to open the workbook for updating throughtout the rest of the day . I tried the windows scheduler but it will email each time I open the workbook. What can I do to get what I want ...is it extra code in the macros or something I missed in the scheduler? Cheers |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Emailing worksheet | Excel Worksheet Functions | |||
Emailing A Worksheet | Excel Worksheet Functions | |||
Emailing a worksheet | Excel Discussion (Misc queries) | |||
Emailing worksheet | Excel Discussion (Misc queries) | |||
Emailing a worksheet | Excel Discussion (Misc queries) |