Solved

Saving Web Page to Excel or ????

Posted on 2002-04-08
5
147 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

Enroll in June's Course of the Month

June's Course of the Month is now available! Every 10 seconds, a consumer gets hit with ransomware. Refresh your knowledge of ransomware best practices by enrolling in this month's complimentary course for Premium Members, Team Accounts, and Qualified Experts.

Question has a verified solution.

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

Introduction In a recent article (http://www.experts-exchange.com/A_7811-A-Better-Concatenate-Function.html) for the Excel community, I showed an improved version of the Excel Concatenate() function.  While writing that article I realized that no o…
Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
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…

696 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