Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Private Sub Import()
Dim ie As Object Set ie = CreateObject("InternetExplorer.Application") With ie .Visible = True .navigate "h++p://www.mywebsite/mywebpage.html" Do While .ReadyState < 4: DoEvents: Loop Range("A1").Value = ie.document.table7.Rows(1).Cells(1) End With ie.Quit Set ie = Nothing End Sub Here is a small code that I wrote to import few values from a webpage. My webpage has a table grid of 5 X 4 (Five columns and Four rows), Name of this table in javascript is "table7" It opens IE, navigates to my page but the following line doesn't execute. What is the correct syntax? Range("A1").Value = ie.document.table7.Rows(1).Cells(1) Maxi |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
importing a web page to excel | Excel Discussion (Misc queries) | |||
Importing Drop down list into new page | Excel Discussion (Misc queries) | |||
Importing Web Page with Hyperlinks into Excel | Excel Discussion (Misc queries) | |||
Importing From web page | Excel Discussion (Misc queries) | |||
Importing Web Page Source Code | Excel Programming |