Question

Locked

Web Query Help

By nbenoni ·
Hello,

Any help would be appreciated, I have no programming background:

I?m trying to set up a Web Query to get the information from a website that lists 100 members per page. The following 100 members are on a slightly different URL. There are over 20,000 members.

For example:
http://tango01.cit.nih.gov/sig/members.taf?_function=list&_start=1&_UserReference=47F3D73C1F201D5D47A3C0CD
http://tango01.cit.nih.gov/sig/members.taf?_function=list&_start=101&_UserReference=47F3D73C1F201D5D47A3C0CD
http://tango01.cit.nih.gov/sig/members.taf?_function=list&_start=201&_UserReference=47F3D73C1F201D5D47A3C0CD

The only part that changes is the start=1 to start=101, start=201 etc.

I?ve written a simple IQY file:

WEB
1
http://tango01.cit.nih.gov/sig/members.taf?_function=list&_start=["Page Number","Please enter a page number:"]

This will prompt in Excel for me to enter a page number.

My question is ? how do I automate the script to query all the subsequent sites so I can get all the members?

Thanks for helping in advance. Sorry if this seems obvious.

This conversation is currently closed to new comments.

0 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Share your knowledge
Back to Web Development Forum
0 total posts (Page 1 of 1)  

Related Discussions

Related Forums