WScript Object not recognised

[AthmanArumugam]

HI All,

I have learnt that WScript object is instrinsic . However when I use the statement
WScript.Sleep 1000, it is throwing an error "Run time error 424: Object required".

Can you let me know if any settings that needs to be set to have WScript object work.

 

[Hui]

Goto VBA (Alt+F11)
Goto the Tools, References menu
Enable Microsoft Scripting Library

 

[AthmanArumugam]

Hi Huui -Thanks for the response. However, even though I have clicked it, still WScript is not working. Find attached the screenshot. Let me know if I have checked the correct reference library.

 

[Marc L]

Hi !

I have learnt that WScript object is instrinsic

No ‼ It does not exist within general VBA !

I use the statement WScript.Sleep 1000

This statement works only in VBScript not in VBA ‼
So when you grab a code on web, check first for which language !

A sample here how to declare another external Sleep function and use it …
​

 

[AthmanArumugam]

Thanks Hui and Mark for your response. However I could find that Application.wait achieves the same functionality done by WScript.Sleep.
Hence I replace WScript.Sleep with Application.Wait

 

[Marc L]

For General VBA yes but not for an external application …​

 

[Chihiro]

Also, sleep allows for more finite control of pause time (i.e. in milliseconds).

Though Wait is more accurate in terms of time. Sleep uses processor's ticks to calculate time delay and may vary slightly on different machines.