Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto running a macro on closing | Excel Discussion (Misc queries) | |||
Running a macro from an auto-refresh | Excel Worksheet Functions | |||
Running auto correct on startup? | Excel Discussion (Misc queries) | |||
Auto generation of 3 levels of running number | Excel Worksheet Functions |