Excel 2010 &A12 not working?
Hi,
I'm using a function from http://finance.groups.yahoo.com/group/smf_addin/
In excel 2003, the formula below works
=RCHGetTableCell("http://investing.money.msn.com/investments/stock-income-statement/?symbol=ca",1,"Operating Income")
But this won't:
=RCHGetTableCell("http://investing.money.msn.com/investments/stock-income-statement/?symbol="&A12,1,"Operating Income")
&A12 is a cell that contains text = "CA". May I know if there is a new syntax in excel 2010 to make &A12 here works?
Last edited by Lewis Koh; 08-11-2013 at 09:11 AM.
You know you have a space between "Operating" and "Income", right?
I have no idea if this will work, but try...
=RCHGetTableCell(INDIRECT("http://investing.money.msn.com/investments/stock-income-statement/?symbol=")&A12,1,"OperatingIncome")
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Yah there is a space in between. That is correct. Anyway, it's works today. Thanks for responding.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks