my iqy file looks like this

WEB
1
http://www.investegate.co.uk/ Index.aspx? searchtype= 5&words=["words","Enter
or select isin:"]&Go=search& os=["os", "enter or select the page no:"]

Selection=10
Formatting=None
PreFormattedTextToC olumns=True
ConsecutiveDelimite rsAsOne=True
SingleBlockTextImpo rt=False
DisableDateRecognit ion=False
DisableRedirections =False

unfortunately the webpage displays only the first 60 records or so..
and the page numbers (os) goes 0, 60, 120 etc (therefore the last bit
after the go=search)

So that is the url. http://www.investegate.co.uk/ .What the site provides is the
RNS feeds of companies listed on the london stock exchange. It is provided free
of charge.

I am working on a paper which uses the news announcements data. My primary
interest is in earnings announcements data but i thought i would get the whole
thing and then filter it out, incase I need to use the other news announcements
later.

So the procedure is to go to the site. Select the menu companies, Then search by
ISIN ( the identifier) to get the news items regarding a company  and then
download it to excel. But with 3500 companies i need to enter the isins and the
page numbers manually each time and scrolling up and down to select the
destination cells. Just the kind of thing u want to get automated.

So ideally my program would look like this

I have the isin nos in the column A, the page numbers say 0,60,120,180...300
max. in column B.

The program selects C1. and then runs the webquery with cell  contents A1 and B1.
A1 for isin and B1 for os.

One the data is downloaded. The active cell moved down to the end of data in
column C. Checks to see if it says No announcements. If dosent say No
announcements Then runs the query  again with A1 and B2.

After that is done say there was only one of data for this company. So when the
program runs with A1 and B2 the value No announcement is returned. So the
program Moves to A2 ( a new isin number) and B1. Then A2 and B2 so and so forth.

I wouldnt mind just getting the program to run  down the isin column alone with
fixed values for the page number. As i can one page at a time for all the
companies. so os is fixed at 0 for the first 3500 runs. Then fixed to 60 for the
nest 3500 runs etc.

The key point is to get the program to move down automatically  to read and pass
the isins to the query.