I am trying to insert a value in an activecell to provide the cell automatically with a link to a webpage the code I have tried is as follows

Activecell.FormulaR1C1 = "=HYPERLINK("http://idxpro.cisdata.net/AR185385/index.php/CISNDID=d5434b361870f297b7f0ed9bf7028181&MODE=View Listing&view_mls_id=WA-TCAOR&view_mls_no=120182", "View")"

The link allows me to view a listing page on the site but I keep getting end of statement expected errors. I can type it in manually and click the "View" text to view the page but VBA will not accept the code as written.

REI

sub mysub()
 ActiveCell.Hyperlinks.Add Anchor:=Selection, Address:="http://idxpro.cisdata.net/AR185385/index.php/CISNDID=d5434b361870f297b7f0ed9bf7028181&MODE=View Listing&view_mls_id=WA-TCAOR&view_mls_no=120182"
 ActiveCell.Value = "View"
end sub
cheers

Matt

Thanks Matt this helps! Now I have to figure out how to call the inline frame update from my default page at http://1rei.com/idxsearchpage.htm

Thanks




REI

My pleasure,

 ActiveCell.Hyperlinks.Add Anchor:=Selection, Address:="http://idxpro.cisdata.net/AR185385"
 ActiveCell.Value = "View"

Cheers

Matt

Thanks again Matt,

The original posting URL gives my client the listing presentation however in order for me to give it a "Proprietary feel" from my site, I had inserted the idx search page in a frame on my site. I am now exploring how to call the inline frame site from within the page at

http://1rei.com/idxsearchpage.htm (frame source call http://idxpro.cisdata.net/AR185385/i..._mls_no=120182)

The frame source would then be the original address you helped with. I think it's a matter of finding the right syntax for the URL in this case.




REI