Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 17
Default How to retrieve and write data to a webpage



I posted this question yesterday, but received no response. I had
researched this website to glean the below code to access a webpage,
however, it is not working for me. Can anyone assist me in where I'm
going wrong? Thanks in advanced.

Dim IE As Object
Dim sHTML As String

Application.ScreenUpdating = True
Set IE = GetObject("InternetExplorer.Application")

With IE
.Visible = True
.Silent = True
.Navigate "http://Intranet/Add/topic_add.asp"
Do Until Not .Busy
DoEvents
Loop
sHTML = .document.documentelement.innerText
.Quit
End With
Set IE = Nothing

My problem is that the code I'm attempting to utilize does not seem to
call the webpage and sHTML doesn't ever get set to anything. If I leave
in the "Do Until" then the program loops infinately.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Reply
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
Saving data to a webpage steve New Users to Excel 2 February 24th 08 09:00 PM
write a query to retrieve data query New Users to Excel 1 March 17th 06 06:01 PM
Linking Webpage to Excel Data Taier Excel Worksheet Functions 1 November 19th 05 12:43 AM
is it possible to execute write to the fields in another .xsl form a macro in another .xsl? e.g. some way to load another .xsl into an .xsl macro and write to its data? Daniel Excel Worksheet Functions 1 June 23rd 05 11:38 PM
Macro to write to webpage & query results Ross[_8_] Excel Programming 0 July 8th 04 02:34 AM


All times are GMT +1. The time now is 02:11 AM.

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

About Us

"It's about Microsoft Excel"