MsgBox date

hi, Irma !

How can I make to open this every day 3 of every month on every day automatic when I open sheet3
and also how can I make this to open every Monday of every week [...]

you have posted in english into an spanish news group :)
i am not that practical with that language... i'm trying to understand your question ;)

-> you say that you need to 'open this'...
- every day 3 of every month ?
-> and/or...
- on every day automatic when you open sheet3 ?
-> and/or...
- every Monday of every week ?

you might want to give a try to windows task-manager ?
-> you are able to programming which file/s are to be opened at a certain date/time/schedule

if any doubt, or a bit more detalied info... would you give us your comments ?

regards,
hector.

TankYou Hector:
This is what i got so far and i need this to open every sunday and i need
another MsgBox For Every 15 of every month

Sub showContentcell()
MsgBox "Dia Domingo" _
& Chr(13) & Range("F10").Text _
& Chr(13) & Range("F11").Text _
& Chr(13) & Range("F12").Text _
& Chr(13) & Range("F13").Text _
& Chr(13) & Range("F14").Text _


End Sub





"Héctor Miguel" escribió en el mensaje
news:e%

hi, Irma !

> How can I make to open this every day 3 of every month on every day

automatic when I open sheet3

> and also how can I make this to open every Monday of every week [...]

you have posted in english into an spanish news group :)
i am not that practical with that language... i'm trying to understand

your question ;)

-> you say that you need to 'open this'...
- every day 3 of every month ?
-> and/or...
- on every day automatic when you open sheet3 ?
-> and/or...
- every Monday of every week ?

you might want to give a try to windows task-manager ?
-> you are able to programming which file/s are to be opened at a certain

date/time/schedule

if any doubt, or a bit more detalied info... would you give us your

comments ?

regards,
hector.

hi, Irma !

This is what i got so far and i need this to open every sunday and i need another MsgBox For Every 15 of every month ...

not so sure i'm following you properly :))

i guess you could let this job in the windows task-manager wise hands... [i.e.]

a) programming n_tasks as your workbook open-days needs...
you can decide start and end dates as well as schedule days [15's, Sundays, etc.]

b) use your workbook_open() event to give some directions according current-task opening-day [i.e.]...
If Day(Date) = 15 Then ... ' call a procedure for days 15 MsgBox
If WeekDay(Date) = 1 Then ... ' call a procedure for Sundays MsgBox
[and so on...]

please, let me know if this seems to be what you need !

regards,
hector.