Need help Importing Data using web query to specific Columns

[raghav007]

Hello Friends ,

I need your help with two issues that am facing.
Am trying to copy information from a webpage http://tinyurl.com/linktopage2

It is a directory.Containing links to every member it has. The info on each page is divided in 3 parts. Name , Business Type , Contact Information.

http://i54.tinypic.com/2j9tm8.jpg
You can see the image on above link to understand what am trying to do.

Now my question is , is it possible to have info collected in specified cells the way I am wanting to do.

And my second question is the macro that am using to fetch information is putting information horizontally in excel.

Here is the macro.

Please Login or Register  to view this content.

I am only two days old at programming. So would highly appreciate if anyone here could help me with this.Thanks to all in advance.

[venkat1926]

I am sending you a file raghava main.xls.
see sheet1. it has the member ship numbers form A2 to A6
After running the macro "test" you get the sheets whose names are the remember ships numbers (same as A2 to A6 in sheet1). see those new member sheets.; I agree some cosmetic changes have to ;be done. let us think about it later. but do you not want some thing like this.


suppose you are generally satisfied with the sheet 1170 to 1175 then for RETESTING
you run the second macro "undo" first and then run the first macro "test" and see whether you get the same result

Note: as you are downloading data and rearranging it it may take some time. for these six members it takes about 20 seconds. that is about 3.5 second for each member). if you have 30 members it will take little less than 2 minutes. keep this in mind.At end of the running the macro "test" you get confirmation message "macro over"

the macros are in vb editor of the file. still I am giving the macro here also

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[/CODE]

[raghav007]

Thanks Venkat. I appreciate your reply. I`ll go through the file once I am on my desk and if I still get a problem i`ll get back to u.
Thanks again.