Object required error

خرید بک لینک

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

صفحه بندی