I am trying to pull public data from a website into an excel file. The website is www.superpages.com
- I want to gather all of my local business listings into an excel file so that i can create a directory on my own webpage. I would also like to know if what I am looking to do is legal. Im not trying to break any laws but I am pretty sure any info that I could, hypothetically get out of a regular phone book and manually eneter wouldnt be illegal to obtain otherwise....right?
I have tried using the web query function inn excel but it seems to only work if there is a table on the site I am pulling from.
p.s. i am not familiar with VB ( i heard it can be done using this program), is there another way?