VBA auto running
 

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

VBA auto running
 

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


-----Original Message-----
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
.

VBA auto running
 

"Frank Stone" wrote in message ...
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


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.