Open Google Chrome via VBA Using Cell

Guard913

Board Regular
Joined
Apr 10, 2016
Messages
144
Office Version
  1. 2016
  2. 2010
Platform
  1. Windows
This is what I have so far: (Opens Chrome No Problem)

VBA Code:
Sub final()
Dim chromePath As String
  chromePath = """C:\Program Files (x86)\Google\Chrome\Application\chrome.exe"""
  Shell (chromePath & " -url https://google.com")
End Sub

However, the
VBA Code:
Shell (chromePath & " -url https://google.com")
needs to point to a cell, and open link in cell, which will change frequently. Code in cell will look like this:
VBA Code:
="https://www.fedex.com/fedextrack/index.html?tracknumbers="&A1&"&cntry_code=us"
Where cell A1 will equal just the tracking number. (Sample Live Tracking Number 02396343498224537337)

Now for anyone really into crazy stuff the ultimate goal would be for it to open the page pull all Tracking Data then put it in the Excel Sheet and Designated spots, but I totes would not be surprised if that doesn't work, but if you'd like to share the code that will make all this come together that would be awesome!!

At the very least I need Chrome to Open to the correct FedEx Tracking page.

Thanks!!!

P.S. If Chrome is unable to do it, then I can use IE, but then I really really want the code to pull data need from IE put it into Excel sheet, and then close IE
 
Last edited:

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Forum statistics

Threads
1,224,817
Messages
6,181,148
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top