You'd have to concatenate the ticker value to the URL address being
used in the function. For example, if your identifier is in cell  A1,
instead of this formula:

=RCHGetHTMLTable("www.investegate.co.uk/Index.aspx\
ndard&Go=search",">Announcement",-1,"",1)

...you'd use something like:

=RCHGetHTMLTable("www.investegate.co.uk/Index.aspx\
&words="&A1,">Announcement",-1,"",1)

> You have also provide a VBA code for the above using the addin as a
> reference in VBA, when I try running the code, its give me an error at
> the line : aData. I don't understand this, would appreciate that you
> enlighten me on this as I am new to VBA.

I would immediately suspect one of two potential problems:

1. The add-in was not set up as a reference library (but you indicate
that has been done?)

2. You pasted the code as shown in the email. It should have only
been three lines -- the SUB statement, the aData statement, and the
END SUB statement. The aData statement wrapped in my email reader, so
it might have in yours. You need to make it a single line (or use
continuation characters if going to multiple lines). For example:

Sub Test()
aData =
RCHGetHTMLTable("http://www.investegate.co.uk/Index.aspx?searchtype=2"
& _
"&words=standard&Go=search", ">Announcement", -1, "", 1, _
pDim1:=61, pDim2:=5)
End Sub