This is what I have so far: (Opens Chrome No Problem)
However, the
needs to point to a cell, and open link in cell, which will change frequently. Code in cell will look like this:
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
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")
VBA Code:
="https://www.fedex.com/fedextrack/index.html?tracknumbers="&A1&"&cntry_code=us"
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: