how can i wait untill the excel in share loaded completely in VBscript 1

[laks143]

how can i make sure that the excel sheet in share is loaded completely.


sheet.workbooks.open "H:\plan\pv.xls",false,true

This sheet will take atleast 4to 5 minutes to open.
do i need to wait the script for 5 min...how can i make it

 

[PHV]

While sheet.Ready = False
WScript.Sleep 1000
Wend

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[markdmac]

Have a star from me PHV for providing such concise and helpful advice.

I hope you find this post helpful.

Regards,

Mark

Check out my scripting solutions at

http://www.thespidersparlor.com/vbscript

Work SMARTER not HARDER. The Spider's Parlor's Admin Script Pack is a collection of Administrative scripts designed to make IT Administration easier! Save time, get more work done, get the Admin Script Pack.