Excel vba 2010.
Thanks to byundt,
I have code directing me to a website.
Function GetIE() As Object
Dim IE As Object, oShApp As Object, oWin As Object
Set oShApp = CreateObject("Shell.Application")
For Each oWin In oShApp.Windows
If TypeName(oWin.Document) = "HTMLDocument" Then
Set IE = oWin
Set oShApp = Nothing
Set oWin = Nothing
If IE Is Nothing Then
Set IE = CreateObject("InternetExplorer.Application")
Set GetIE = IE
Dim IE As Object
Dim t As String
Set IE = GetIE()
t = "11509957"
IE.Navigate ("http://www.fastenal.com/web/products/detail.ex?sku=" & t & " ")
Once i'am at a website:
I need to know if there is way to extract data from a webpage...if i know what html code to look for..
in this case: but not the website above..
The vaue i'm wanting is the value after the
say to a textbox 2 on my userform...