Forgive me for trying to get into something way above my skill level but I am trying to write a macro in VBA to send data to a website and collect a quote and retu it to the workbook but I keep getting an "object Required" error. As I said I am above my skill set and it is probably a pretty easy solution to this.
This is what I have so far;
Sub SelectCar1()
'Dim IE As New InteetExplorer
IE.navigate "http://www2.rlcarriers.com/freight/shipping/rate-quote?ctl00$cphBody$txtOriginZipCode=" & Range("origin").Value
Do
DoEvents
Loop Until IE.readyState = READYSTATE_COMPLETE
Dim Doc As HTMLDocument
Set Doc = IE.document
Dim sTD As String
sTD = Trim(Doc.getElementsByTagName("td").innerText)
IE.Quit
Dim rdd As Variant
rdd = (sTD)
Range("carrier1results").Value = rdd
Recent Questions...
ما را در سایت Recent Questions دنبال میکنید
برچسب:
نویسنده: استخدام کار
بازدید: 236
تاريخ: چهارشنبه
16 تير
1395 ساعت: 23:40