Saving Web Page to Excel or ????

I am using the following to capture data from a web page.

Openfile="http://www.   etc   .html

        IEObj.Navigate "" & Openf
        IEObj.Visible = False

Private Sub IEObj_DocumentComplete(ByVal pDisp As Object, URL As Variant)


 Print #1, IEObj.Document.documentelement.outertext


The pages are very standard in format, but are not tables.

Is there any way of capturing the contents of the web page to say EXCEL or ??, so that the text contents are in some form of consistant format.

At the moment i have to parse each line and work all the data out. ( a lot of work)!!

Appreciate any advice

turnermichAsked:
Who is Participating?
 
bruintjeConnect With a Mentor Commented:
Hi Turnermich,

You can use webqueries, for an example

http://216.239.37.100/search?q=cache:tzgvQY_u2D0C:www.15seconds.com/issue/991021.htm+how+to+excel+web+query&hl=nl

I use them also a lot for data related things,

XL97 version- a bit clumsy, you've to set up things with an extra sheet where you dump the page and link to that one form another or pick the data you want

XL2K version - much better you can pick the table if you know wher it is on the page so you only import that one + autoupdate

XLXP version - tops, you cn see and choose whihc table to import

I use them in programming or manual and they are very handy, better at least then import the page and parse it although that could be done this is fast and easy

HTH:O)Bruintje
0
 
rkot2000Commented:
you can modify your pages to send all data to excel :
 just like this:

first line in the page :
<% Response.ContentType = "application/vnd.ms-excel"  %>

<html>
<head>
 <meta NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
 <link rel="stylesheet" type="text/css" href="../_style/ReportStyle.css">
<body target="fradetails">

0
 
Richie_SimonettiIT OperationsCommented:
hearing...
0
 
turnermichAuthor Commented:
Thanks for your advice.
I did not realize that Microsoft had this feature.

Appreciate all comments and advice.


Regards turnermich
0
 
bruintjeCommented:
glad it got you going
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.