<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div><div>On Sep 9, 2009, at 9:25 PM, Will Martin wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Hi, Robert.</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><br></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">I wish I could help, but your description of the feature is a little vague. Would you mind providing an actual URL to one of the Web pages you are talking about, and a description of the specific data somehow linked between the URL and the spreadsheet? It might give the rest of us more to go on.</div></blockquote></div><div><br></div>This URL is used to get the CBOE Volatility Index (VIX). In Windows Excel, you can actually select that item from the web page. That is all you will get, and as far as I have been able to determine you will get it no matter where it ends up on the page. Excel 2004 for Mac loads the entire page and the VIX data drifts up and down depending on what other information the CBOE chooses to include in its page. The cells for High, Low and Close are always next to one another but they may move up or down a couple of lines in the spreadsheet each day. This means you must always check to be sure the data you extracted is the data you actually wanted.<br><div><br></div><div><!--StartFragment--> <div class="MsoNormal"><a href="http://www.cboe.com/data/mktstat.aspx">http://www.cboe.com/data/mktstat.aspx</a><o:p></o:p></div> <!--EndFragment--> </div></body></html>