Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Open Google Chrome from VBA/Excel

Tags:

I'm trying to open a Chrome browser from VBA. I understand Chrome does not support ActiveX settings so I'm curious if theres any work-arounds?

Dim ie As Object 
Set ie = CreateObject("ChromeTab.ChromeFrame")
ie.Navigate "google.ca" 
ie.Visible = True
like image 540
Sam Avatar asked May 06 '11 18:05

Sam


People also ask

Can you use VBA to pull data from website?

You can use VBA to extract data from web pages, either as whole tables or by parsing the underlying HTML elements. This blog shows you how to code both methods (the technique is often called "web-scraping").


2 Answers

shell("C:\Users\USERNAME\AppData\Local\Google\Chrome\Application\Chrome.exe -url http:google.ca")
like image 148
ray Avatar answered Sep 21 '22 02:09

ray


Worked here too:

Sub test544()

  Dim chromePath As String

  chromePath = """C:\Program Files\Google\Chrome\Application\chrome.exe"""

  Shell (chromePath & " -url http:google.ca")

End Sub
like image 27
ahmad Avatar answered Sep 18 '22 02:09

ahmad