Workbook_Open VBA

[pujo]

I have a WorkBook on a network drive.
The network is EXTREMELY SLOW, When I open the workbook, the Workbook_Open event is triggered.
Being that the network is slow, the code is executing before the workbook is completely opened thus causing errors.

Is there a way I can delay the Workbook_Open code until the workbook is fully opened, and ready?

I've tried this, but doesn't work. Seems it is always "Ready"

If Not Application.Ready = True Then

Appreciate the assistance!

 

[Cubist]

Try to set a timer.

Private Sub Workbook_Open()
    Const delayInterval As Integer = 1000 ' Adjust as needed
    Application.OnTime Now + TimeValue("00:00:01"), "YourNormalSubGoesHere"
End Sub

 

[pujo]

Getting an overflow error on "Const delayInterval As Integer"

 

[Cubist]

Getting an overflow error on "Const delayInterval As Integer"

The value you've assigned to delayInterval is probably too large for the Integer data type. Change to Long.

 

[pujo]

Got it. Many thanks!