We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
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 Exit For End If Next If IE Is Nothing Then Set IE = CreateObject("InternetExplorer.Application") End If Set GetIE = IE End Function Sub test() 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 & " ") End Sub
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|modify formula for range changes||8||27|
|window API declaration what is the difference between these two||3||20|
|Adjusting a Button Control to register a different number||12||32|
|date format is changing when i run the macro||3||15|
Join the community of 500,000 technology professionals and ask your questions.