How to run IE with VBA using Selenium

Question

How to overcome the IE Zoom Problem when launching it from VBA using Selenium? I have found only some code for other languages, but could not find anything for VBA. Thank you in advance

Yu Zhou · Answer 1 · 2020-07-07T06:27:21.707

2

You can't use Selenium IEDriver if you don't set IE zoom level to 100%. One of the required configuration of using Selenium IEDriver is that:

The browser zoom level must be set to 100% so that the native mouse events can be set to the correct coordinates.

Only with the zoom level set to 100% then we can launch IE from VBA using Selenium.

Reference link: How to ignore zoom setting

Edit:

If you have opened IE through Selenium VBA then you could use the following code to zoom in the webpage:

driver.ExecuteScript "document.body.style.zoom='200%';"

edited Jul 07 '20 at 06:27

answered Jul 06 '20 at 09:10

Yu Zhou

11,532
1
8
22

I've managed to open the IE - thank you. Now I would need something to ignore the zoom level as everything is super small. How can I zoom the page back and keep Selenium work (or will it brake?). The linked question is about the error itself which is no longer a problem for me. Thank you in advance. – JakubTracz Jul 06 '20 at 18:33
Ok, I've just used Send Keys. I hope it's a good way to do so. – JakubTracz Jul 06 '20 at 18:45
From your last comment, it seems that you have fixed the issue. Based on your explanation in the comment, I also updated my answer. Please check it. – Yu Zhou Jul 07 '20 at 06:37

score 0 · Answer 2 · answered Jul 05 '20 at 17:18

0

Try such code

Sub Test()
    Dim bot As New IEDriver
    With bot
        .Get "https://www.google.co.uk"
        .Window.Maximize
        Stop
        .Quit
    End With
End Sub

answered Jul 05 '20 at 17:18

YasserKhalil

9,138
7
36
95

Did you install selenium properly? Review this [LINK](https://stackoverflow.com/questions/57216623/) – YasserKhalil Jul 05 '20 at 18:48
The linked question is about Chrome - for me it's working with Chrome, so not quite sure. – JakubTracz Jul 05 '20 at 19:55
The code is working for me. I have windows 10 64 Bit and Internet Explorer 11 and Office 365 32 Bit .. Make sure the IE is installed correctly. – YasserKhalil Jul 05 '20 at 20:20

How to run IE with VBA using Selenium

2 Answers2