0

In one of my requirement i have to open one internal website and pull the data from that page. But the website has some limitations that it will open in Chrome only. I have experience in automating IE, I tried the same way of creating object for Chrome.

Set CHromeapp = CreateObject("Chrome.Application")

But its throwing error as "activex component can't create object". Can any one help me to create an object and navigate to Chrome.

1
  • What happens if you try to open the website with IE
    – Dave
    Dec 12, 2017 at 13:43

2 Answers 2

2

Google Chrome is not a .NET application, therefore you cant create a VBA object.

-1

Sub test544()

Dim chromePath As String

chromePath = """C:\Program Files (x86)\Google\Chrome\Application\chrome.exe""" Shell (chromePath & " https://www.oanda.com/currency/converter/")

End Sub

2
  • This works fine May 27, 2018 at 13:27
  • 1
    Explain your answer.
    – Biswapriyo
    May 27, 2018 at 13:46

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .