Run time error 1004 - Method OnTime of Object _Application failed.

[danbates]

Hi,

Please can someone help?

I have a file I am trying to open from another excel file with the following code:

Sub CILHyperLink()
Workbooks.Open ("C:\XxudV7g3hu\Dan Bates\Palletiser\2020\Palletiser CIL Sign Off.xlsm")
End Sub

but when I do I get the Run time error 1004 - Method OnTime of Object _Application failed on the second line of the following code:

Sub StopTimer()
    On Error Resume Next
    Application.OnTime EarliestTime:=DownTime, Procedure:="ShutDown", Schedule:=False
 End Sub

but when I open the file straight from a shortcut off the desktop of the PC, it opens normally without the error.

Any help would be appreciated.

Thanks

Dan

 

[rlv01]

The two subroutines are (seemingly) unrelated. How does running the first one produce an error in the second one? I feel like something is missing from your problem description.

 

[danbates]

Hi,

I've just searched through the code and I found these 2 codes.

Private Sub Workbook_SheetCalculate(ByVal Sh As Object)
    Call StopTimer
    Call SetTimer
End Sub

Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, _
  ByVal target As Excel.Range)
    Call StopTimer
    Call SetTimer
End Sub

Do these give you a better idea?

Thanks

Dan

 

[braindiesel]

Are uyu certain that the filepath or filename has not changed

 

[danbates]

Hi,

I have just opened the file from my shortcut on my desktop and now I'm getting the same error when I enter my data, but not when the file is opening.

I have found the code I am using online and I have copied a pasted it in again just in case I had done something to it but I am still getting the error.

This is the code I have been using:

Forcing a Workbook to Close after Inactivity

Tired of your workbooks being left open on the screen where they can be seen by anyone passing by? Here's a way to have Excel automatically close a workbook after a given period of time.

excelribbon.tips.net