| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting a macro to perform a function on a certain day every week.
If Weekday(Date, vbSunday) = 3 Then MsgBox "Produce the Tuesday Report."
-- Vasant "Ian M" wrote in message om... I run a macro daily in an Excel Workbook to produce certain data. However, every Tuesday I have to get the macro to perform an extra task which I do not require it to perform on any other day say, for example, for a message box to appear saying "Produce the Tuesday Report". How can I write an extra clause so that if I run the macro on a Tuesday the message box will appear, but if I run the macro on any other day, it will not. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a function to perform this operation? | Excel Discussion (Misc queries) | |||
| I cannot perform this function PLEASE HELP! | Excel Worksheet Functions | |||
| What function does ^ perform in a formula | Excel Worksheet Functions | |||
| perform 1 function, stop, perform different function | Excel Discussion (Misc queries) | |||
| How to perform the following function in Excel? | Excel Worksheet Functions | |||
Threaded Mode
