Save html file from web site with out opening browser

Posted on 2004-09-21
Last Modified: 2010-05-02
ok i need to make an app that grabs a html page from a website and saves its to disk
the web site updates every few minutes
and i want my app to run in the background and grab this updated page every ... so often..
Question by:apinsonn
LVL 18

Assisted Solution

bobbit31 earned 75 total points
ID: 12113063
reference ms internet controls under project/references:

Dim IE As New InternetExplorer

IE.Navigate ""

'wait for page to load

Dim strHtml as string
strHtml = IE.document.body.innerHTML

msgbox strHtml

Dim ff as integer
ff = FreeFile

Open "<path to file>" For Output as #ff
Print #ff, strHtml
LVL 18

Expert Comment

ID: 12113065
and put the above in a timer
LVL 18

Expert Comment

ID: 12113109
oh and don't forget to clear resources:

set IE = nothing

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

LVL 32

Accepted Solution

Erick37 earned 75 total points
ID: 12113254
You can use the URLDownloadToFile API

Private Declare Function URLDownloadToFile Lib "urlmon" Alias _
"URLDownloadToFileA" (ByVal pCaller As Long, ByVal szURL As String, ByVal _
szFileName As String, ByVal dwReserved As Long, ByVal lpfnCB As Long) As Long

Use like this:

returnValue = URLDownloadToFile(0, "", "c:\ms.htm", 0, 0)

How To Download a File Without Prompting;en-us;244757

LVL 51

Expert Comment

by:Ryan Chong
ID: 12113320
Also Ensuring URLDownloadToFile Bypasses a Cached File Copy:

Author Comment

ID: 12113473
both work great split the points

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

Introduction I needed to skip over some file processing within a For...Next loop in some old production code and wished that VB (classic) had a statement that would drop down to the end of the current iteration, bypassing the statements that were c…
Introduction In a recent article ( for the Excel community, I showed an improved version of the Excel Concatenate() function.  While writing that article I realized that no o…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

821 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