Solved

Saving Web Page to Excel or ????

Posted on 2002-04-08
5
146 Views
Last Modified: 2012-05-04
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

0
Comment
Question by:turnermich
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 44

Accepted Solution

by:
bruintje earned 50 total points
ID: 6927314
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
 
LVL 5

Expert Comment

by:rkot2000
ID: 6928225
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
 
LVL 16

Expert Comment

by:Richie_Simonetti
ID: 6929136
hearing...
0
 

Author Comment

by:turnermich
ID: 6929534
Thanks for your advice.
I did not realize that Microsoft had this feature.

Appreciate all comments and advice.


Regards turnermich
0
 
LVL 44

Expert Comment

by:bruintje
ID: 6929562
glad it got you going
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There are many ways to remove duplicate entries in an SQL or Access database. Most make you temporarily insert an ID field, make a temp table and copy data back and forth, and/or are slow. Here is an easy way in VB6 using ADO to remove duplicate row…
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question