Web Query Help

By nbenoni ·

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:

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

I?ve written a simple IQY file:

1["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