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.
