LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 94
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
importing a web page to excel hetal patel Excel Discussion (Misc queries) 0 September 9th 09 11:39 PM
Importing Drop down list into new page ConfusedKip Excel Discussion (Misc queries) 2 October 23rd 08 11:20 AM
Importing Web Page with Hyperlinks into Excel feltra Excel Discussion (Misc queries) 10 August 8th 07 01:17 AM
Importing From web page graeme Excel Discussion (Misc queries) 1 May 16th 07 04:07 PM
Importing Web Page Source Code tx12345[_6_] Excel Programming 5 January 22nd 06 12:16 AM


All times are GMT +1. The time now is 07:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"