Web Development

Our forums are currently in maintenance mode and the ability to post is disabled. We will be back up and running as soon as possible. Thanks for your patience!

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.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums