View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Matt[_27_] Matt[_27_] is offline
external usenet poster
 
Posts: 2
Default 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.