Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Importing values from a web page
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Importing values from a web page
does the table7 have the same name of the excel sheet your using it-in. Make sure there is no confliction between the table and the excel work sheet name. Check for conflictions with your objects, sometimes using the same name twice might conflict with objects. To check this make sure when using the Appendix of Table7.Rows <-- Make sure .Rows Shows up in the index listing before you append it to the object. -- shawnRheal ------------------------------------------------------------------------ shawnRheal's Profile: http://www.excelforum.com/member.php...o&userid=34870 View this thread: http://www.excelforum.com/showthread...hreadid=546163 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Importing values from a web page
I wrote this line "Range("A1").Value =
ie.document.table7.Rows(1).Cells(1)" without knowing whether the syntax is right or wrong. I think there is some problem with this line. To answer your question, name of my excel file is bd.xls and sheet name is sheet1. There are no confilicts. shawnRheal wrote: does the table7 have the same name of the excel sheet your using it-in. Make sure there is no confliction between the table and the excel work sheet name. Check for conflictions with your objects, sometimes using the same name twice might conflict with objects. To check this make sure when using the Appendix of Table7.Rows <-- Make sure .Rows Shows up in the index listing before you append it to the object. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |