Question
Thread display: Collapse - |
All Answers
Share your knowledge
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Web Query Help
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.