But the code wants to run all at once, in a millisecond. By the time IE actually loads the page of search results, the entire subroutine is long over. We have to slow things down and wait for the browser while its navigating. We could use something like Application.Wait(Now + TimeValue("00:00:05")) to wait 5 seconds, but if the page loads faster we’re wasting time waiting for nothing, and if the page takes longer we’re in the same pickle as before. Do While objIE.Busy = True Or objIE.readyState <> 4: DoEvents: Loop is an elegant Do...Loop solution consisting of 3 VBA statements we’ve tidied up on one line, using colons (:) to connect them. It’s saying: while IE is busy navigating, just sit here and run in circles. objIE.Busy = True and objIE.readyState <> 4 (<> means not equal) are essentially the same thing –one could probably be ommitted– but just to make sure the page is really done loading we make both of these conditions requirements for getting out of the loop, by using the logical operator Or. The DoEvents part is technically not needed but we add it in the loop to free up processing resources and allow other things to happen within Excel during this time, asynchronous to the running loop. For the over-achievers out there, here are some other ways we could have written this line of code to do the same thing.
Automation of homes and home appliances is also thought to impact the environment, but the benefits of these features are also questioned. A study of energy consumption of automated homes in Finland showed that smart homes could reduce energy consumption by monitoring levels of consumption in different areas of the home and adjusting consumption to reduce energy leaks (such as automatically reducing consumption during the nighttime when activity is low). This study, along with others, indicated that the smart home’s ability to monitor and adjust consumption levels would reduce unnecessary energy usage. However, new research suggests that smart homes might not be as efficient as non-automated homes. A more recent study has indicated that, while monitoring and adjusting consumption levels does decrease unnecessary energy use, this process requires monitoring systems that also consume a significant amount of energy. This study suggested that the energy required to run these systems is so much so that it negates any benefits of the systems themselves, resulting in little to no ecological benefit.[54]
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   
des outils de compréhension de la structure des systèmes et de leur comportement, et une composante pratique car l'automatique a pour fin de faire fonctionner des systèmes en minimisant l'intervention humaine pour éviter toutes sortes de tâches fastidieuses, répétitives ou dangereuses, et donc d'en permettre l'automatisation […] Lire la suite☛ http://www.universalis.fr/encyclopedie/automatique/#i_2513
cents ans. Mais les outils numériques peuvent influencer leur mise en œuvre. Par exemple, pouvoir fournir immédiatement un retour pertinent à un élève lors de la réalisation d’une série d’exercices peut favoriser le processus d’automatisation. De même, pour comprendre un phénomène dynamique complexe (comme le galop du cheval), le fait de pouvoir […] Lire la suite☛ http://www.universalis.fr/encyclopedie/apprentissage-avec-le-numerique/#i_2513
×