Driving A Website Using VBA And Selenium

I have to log into SnapSurveys and download 20+ files monthly. Already a tedious process, I now have to do it weekly instead and it will be beyond tedious to do it by hand, so I wa

Solution 1:

The login functionality is inside an iframe. You have to switch selenium's focus to that iframe and then try again and it should work.

You can try this:

Driver.switchtoframe (0)
Driver.FindElementById("UserName")

Some knowledge about web design can help a long way when dealing with selenium to automate, but with just some basic knowledge you can get the work done easily.

What element you should be looking for depends on what you are trying to achieve. If you want to enter something in a text field, you should be looking for <input type="text"> elements, for table's you need to be looking for <table> elements.

I usually prefer using find elements by xpath, but if the element has a unique id or class on the webpage, you can use find element by class name or find element by id.

You seem to be going on the right track to automate your task.