MsgBox date

19/08/2006 - 20:39 por IRMA MENDOSA | Informe spam
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

Thanks in advance



Sub showContentcell()
'MsgBox "Cell A1 = " & Range("A1").Text
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
 

Leer las respuestas

#1 Héctor Miguel
20/08/2006 - 05:40 | Informe spam
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.

Preguntas similares