Get a text from a webpage

[ROland58]

Hello every one, I'm new to forums I'm not a programmer I only learn things of the net hoping to get some help with MS Access code
What I'm looking for is an event code on textbox will get an unknown word between two known words in already open Webpage

 

[Galaxiom]

Unfortunately that is very advanced stuff for a "non-programmer". You will need to get some understanding the IE Object Model and the page structure.

The process is often referred to as "Screen Scraping". Try searching that term.

 

[ROland58]

Unfortunately that is very advanced stuff for a "non-programmer". You will need to get some understanding the IE Object Model and the page structure.

The process is often referred to as "Screen Scraping". Try searching that term.

--------------------
Alright maybe at least a click event on a textboxA will copy the specified webpage then paste it in another textboxB then I use my existed trim code on textboxB

 

[Galaxiom]

--------------------
Alright maybe at least a click event on a textboxA will copy the specified webpage then paste it in another textboxB then I use my existed trim code on textboxB

If you don't care where it is on the page then you could simply save the page, read it as a text file into a string and apply your current technique to that string.

The GetWebpage function on this page might do what you want.

 

[ROland58]

If possible could you show me in code

 

[HiTechCoach]

If possible could you show me in code

The link Galaxiom provided does show the code. Were you able to view the link?

As Galaxiom pointed out what you want to do is not a simple task. It will require you to do some coding. We are here to help you learn. That is why we give you examples and hints to get you in the right direction. It is up to you to learn how the code works and write the code you need for your specific project.

Another possible is to use the Web Browser Control (WBC). This allows you to an access the text of the web page similar to a textbox. In 201 there is not a native WBC control in the toolbox.

 

[Galaxiom]

If possible could you show me in code

You posted this response four minutes after I provided the link to the code that will do the job. You could at least make an attempt to use that code before asking for it to be done for you.

Paste the pieces of code on that page into a Standard Module in the VB editor.

Open an IE window. Run the Sub TestGetWebpage by putting the cursor in the sub code and clicking on the Run button (or the top entry in the Run menu or press F5).

The VB compiler will complain that it can't find a sub/function. The missing functions are on the MSXML Library Functions page the author links to.

Copy the missing functions from there into the module and repeat until the Test runs without errors. The immediate window should then display the contents of the webpage.

This is pretty basic stuff that you need to understand if you want to be a developer.

 

[ROland58]

thanks guys for the help I guess I can start from Here, the link will help me so much, Many thanks.