VBA auto running

M

Matt

Hello,

I am trying to create an automated way to run an application. I want
to be able to run another application, once a day at a set time, but
not to run on Sunday.


Is this possible ?

Thanks in advance
 
F

Frank Stone

hi,
What is the other application.
here is a time delayed macro i use daily. it skips
weekends. but this calls another excel macro(macAStart)
which runs in excel. i am not sure you can run another
application with excel. if it isn't excel, you may want to
check out Lotus Notes.

Sub macALaunchMR()
If Weekday(Now()) = 6 Then '1 = Sunday, 2 = Monday
Application.OnTime Now() + 2.5 + TimeValue
("00:00:01"), "macAStart"
Else
Application.OnTime TimeValue("05:00:00"), "macAStart"
End If
End Sub
 
M

Matt

Frank Stone said:
hi,
What is the other application.
here is a time delayed macro i use daily. it skips
weekends. but this calls another excel macro(macAStart)
which runs in excel. i am not sure you can run another
application with excel. if it isn't excel, you may want to
check out Lotus Notes.

Sub macALaunchMR()
If Weekday(Now()) = 6 Then '1 = Sunday, 2 = Monday
Application.OnTime Now() + 2.5 + TimeValue
("00:00:01"), "macAStart"
Else
Application.OnTime TimeValue("05:00:00"), "macAStart"
End If
End Sub
Click to expand...

The programme i am trying to run is Called Inform, it is a programme
for reporting and recording data through Access. It allows for VBA
programmed plug-ins to work, i am aware of another person/company that
does this with there software.
 
Top