Shell Error?

[esthetiques]

Does anyone know how to open a program using anything other than the "shell" command? I keep getting a runtime error '5' everytime I click the button. It used to function but now I don't know what caused it to create the error.
Any help will be appreciated

Private Sub cmdSchedule_Click()
 
'Open Task External Scheduler
Shell "C:\Program Files\NCMS\Task Scheduler\Task Scheduler.exe"
 
 
End Sub

[dglienna]

not sure about the error, but there is another way to schedule tasks.

just use the "AT" command. for info, type "AT /?"

it should do what you want, as it uses the task scheduler

[Chrispybee]

Runtime Error 5 is Access Denied.

What system are you running on and make sure that your administrator or got sufficent rights.

[esthetiques]

I am the administrator, but its not just my task scheduler, i have another file telnet.bat using the shell command as well and its the same error.
The error says "invalid call or argument'

Where do I use the AT command?

[esthetiques]

???

[dglienna]

AT commands can be used to program the task scheduler to perform tasks at given times.

post the code you are using for the shell command. you have to give it the correct path before or when you shell a file.

[RobDog888]

I think the regular shell command cant handle spaces in the paths
too well. Try using the hellExecute API instead.

Option Explicit
 
Private Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" (ByVal hwnd As Long, ByVal lpOperation As String, _
ByVal lpFile As String, ByVal lpParameters As String, ByVal lpDirectory As String, ByVal nShowCmd As Long) As Long
 
Private Const SW_SHOWNORMAL As Long = 1
Private Const SW_SHOWMAXIMIZED As Long = 3
Private Const SW_SHOWMINIMIZED As Long = 2
 
Private Sub Command1_Click()
    ShellExecute Me.hwnd, "OPEN", "C:\Program Files\NCMS\Task Scheduler\Task Scheduler.exe", vbNullString, "C:\", SW_SHOWNORMAL
End Sub

HTH

[dglienna]

+S