As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance. If this question can be reworded to fit the rules in the help center, please edit the question.

De plus en plus présents en entreprises, les assistants virtuels contribuent eux aussi à l’automatisation de certaines tâches professionnelles. Dans notre article, « L’assistant virtuel de demain : un cerveau global ? » nous vous parlions notamment d’Astro qui permet de faire rapidement le tri dans ses e-mails et de Findo dont le rôle est de naviguer dans nos boîtes mails, fichiers et cloud personnel pour y trouver l’information que l’on cherche. Et bien sûr, pour automatiser vos RDV il y a Julie Desk 😉

Industrial robotics is a sub-branch in the industrial automation that aids in various manufacturing processes. Such manufacturing processes include; machining, welding, painting, assembling and material handling to name a few.[85] Industrial robots utilizes various mechanical, electrical as well as software systems to allow for high precision, accuracy and speed that far exceeds any human performance. The birth of industrial robot came shortly after World War II as United States saw the need for a quicker way to produce industrial and consumer goods.[86] Servos, digital logic and solid state electronics allowed engineers to build better and faster systems and overtime these systems were improved and revised to the point where a single robot is capable of running 24 hours a day with little or no maintenance. In 1997, there were 700,000 industrial robots in use, the number has risen to 1.8M in 2017[87]

…the line of code is highlighted in the Firebug console (I added the red box around the ID). The image above reminds us a webpage is organized in a nested, tree-like structure, starting with .document as the root object and branching out from there into smaller objects. This is called the Document Object Model. .getElementById("__") is the go-to tool for grabbing one of those objects from the webpage. With it you can scrape data from a page, as well as writing to a webpage as we’re doing here. Here’s a sneak peak at some other ways we could have found the search box and entered data into it (shown in the order I would have tried them, if an ID was not available).
Awesome – your bot just opened your IE browser! Properties (characteristics, such as making IE Visible) and Methods (actions) are invoked after typing a dot (.) after an object, like you see here. In your VBE, delete this line and start retyping it. You’ll notice after typing objIE. that the Intellisense helper pops up, listing all the properties and methods available for the InternetExplorer object. Go ahead and scroll through the list.
I’ve used other automation tools besides VBA. Ubot and iMacros are both excellent, and powerful programs (their own programming languages, really). In some respects they’re easier, and for 99% of web automation tasksg, you really can’t go wrong with either. But I got to where I only used VBA because my programming was getting into Windows API’s and command line calls (Visual Basic is tightly integrated with Windows), plus I often found myself using Excel alongside these programs anyway. I discovered there’s almost nothing VBA can’t do with automating Windows and Internet Explorer (even making IE appear as a different browser), and it seemed to me investing time learning Microsoft’s Visual Basic programming language just made more sense.
×