View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
zen65 zen65 is offline
external usenet poster
 
Posts: 2
Default Need some macro codes

So, now I have to run only the "DailyProgram" and it automatically takes
care of the "WeeklyProgram". That sounds great! Much appreciate your help.
Thank you Jim.

zen65

"Jim Cone" wrote in message
...

Something like this?...
'--
Sub DailyProgram()
'Existing code followed by...
If WeekDay(Date, vbSunday) = vbFriday Then
Call WeeklyProgram
End If
End Sub
'--
Sub WeeklyProgram()
'Existing code here
End Sub
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"zen65"
wrote in message
I have two separate macro programs:
1. Run_Daily() - which is run each day, Monday to Friday.
2. Run_Weekly() - which is run only on Friday.
How can I combine them into a single program so that they still run
correctly?
Thank you for any help.
zen65