VB web access

Posted on 2003-03-03
Medium Priority
Last Modified: 2010-04-07
I'm trying to make a program that will take data off a website and assign it to variables in the program, but i have no idea how to get it to get the data externally :s (sorry, new to vb programming and i hate it)

Any help would be great

Question by:matrices
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
  • 2
  • 2
LVL 14

Expert Comment

ID: 8057129
You can fetch data with the INET or WEBBROWSER control, but what info do you want to fetch from the web ? Are we talking about an entire page or a part oof that page

Author Comment

ID: 8057170
part of the page, i basically want to check which of a selection of images are in use and for the program to assign a value to an array

pictures 1, 4, 22, 6, 2 are on the page then to copy them into an array that i can fiddle with

LVL 14

Accepted Solution

aelatik earned 600 total points
ID: 8057301
Here, this will fetch the source between the body tags ( you have to search for what you want inside the result of GetHTMLCode.

Private Sub Form_Load()
GetHTMLCode ("http://www.google.com")
End Sub

Public Function GetHTMLCode(URL As String)
   Dim IE
   Set IE = CreateObject("InternetExplorer.Application")
       IE.Navigate URL
       While IE.Busy
           GetHTMLCode = IE.Document.body.innerHTML
           'Replace above line with below if you want the entire page instead of the body tags
           'GetHTMLCode = IE.Document.documentelement.innerHTML
   MsgBox GetHTMLCode
End Function

Expert Comment

ID: 8057327
can you guys help me out also?


it's about filling stuff in on a webpage

Author Comment

ID: 8057370

thats great buddy



Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes…
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…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…
Suggested Courses
Course of the Month10 days, 23 hours left to enroll

770 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