PDA

View Full Version : Copy website content in to excel



greenculture
12-07-2013, 10:22 PM
Copy website content in to excel (Search result)


i have 25000 links i want to get all text from those links..

i want a vba script to do this

SamT
12-08-2013, 12:54 PM
:funnyashe




http://www.vbaexpress.com/consulting.php

or

GetRight DL Manager.

or

you can consider this post a bump and await another solution.

ashleyuk1984
12-08-2013, 05:25 PM
Give us with one of the links.... and give us an example on how you want the text to be displayed.

greenculture
12-08-2013, 09:51 PM
i want to get like this

ashleyuk1984
12-09-2013, 12:13 AM
I see, so your collecting a bunch of names and dates.
Well, to code your script correctly, we'll need to see the website. So supply at least ONE link.
We need to see the HTML script and code it up to grab the correct tags. Without knowing this information, there's not a lot we can really do.

greenculture
12-09-2013, 01:48 AM
this is link portal.maccem.com.au:8080/cgi-bin/portalnew.sh/portal/namesenq.p?surname=A&firstname=&othernames=&knownas=&yearfrom=&yearto=&postfunc=Search&companyid=3&scrollx=0&scrolly=0

i want to get all links from this website


surname=A surname=Aaaa surname=Aaab surname=Aaac.................surname=Aaba surname=Aabb

greenculture
12-09-2013, 01:51 AM
Pls view this txt to get links....

i am a new member i cant post links here

greenculture
12-09-2013, 01:52 AM
thnx for your help.....

greenculture
12-09-2013, 01:53 AM
can you post a template here....
i want to grab all data from that website

greenculture
12-09-2013, 01:56 AM
here is the link

h t t p : / / portal.maccem.com.au:8080/cgi-bin/portalnew.sh/portal/namesenq.p?surname=A&firstname=&othernames=&knownas=&yearfrom=&yearto=&postfunc=Search&companyid=3&scrollx=0&scrolly=0

greenculture
12-09-2013, 02:48 AM
this article will help to solve the problem.... but i dont know how to edit...
mrexcel.com/tip072.shtml