<div>
getting an &quot;Invalid procedure call or argument&quot; error message.<br />
<br />
Does this work for you?<br />
<br />
Am I missing a library reference?
</div>


getting an "Invalid procedure call or argument" error message.

Does this work for you?

Am I missing a library reference?

<div>
try commenting out .CommandType = 0 and see if that works
</div>


try commenting out .CommandType = 0 and see if that works

<div>
well, that was easy, thanks!<br />
<br />
Can I ask, on the most basic level, what is this doing, going in and looking for a table and just grabbing it? What if there were 2 tables on the page?
</div>


well, that was easy, thanks!

Can I ask, on the most basic level, what is this doing, going in and looking for a table and just grabbing it? What if there were 2 tables on the page?

<div>
Thanks!<br />
<br />
Basically, the '.WebSelectionType' is where it specifies which table to retrieve. &nbsp;You can set it to 'xlSpecifiedTables' then specify which tables using the '.WebTables' property.<br />
<br />
Here is a an example<br />
<a href="http://msdn.microsoft.com/en-us/library/office/aa215965(v=office.11).aspx" rel="ugc">http://msdn.microsoft.com/en-us/library/office/aa215965(v=office.11).aspx</a>
</div>


Thanks!

Basically, the '.WebSelectionType' is where it specifies which table to retrieve.  You can set it to 'xlSpecifiedTables' then specify which tables using the '.WebTables' property.

Here is a an example
http://msdn.microsoft.com/en-us/library/office/aa215965(v=office.11).aspx [http://msdn.microsoft.com/en-us/library/office/aa215965(v=office.11).aspx]

<div>
<div class="content wysiwyg-content">
Very simply, how do I extract this table, using Excel VBA, into Excel?<br />
<br />
<a href="http://www.treasurydirect.gov/RI/OFNtebnd" rel="ugc">http://www.treasurydirect.gov/RI/OFNtebnd</a>
</div>
</div>


Very simply, how do I extract this table, using Excel VBA, into Excel?

http://www.treasurydirect.gov/RI/OFNtebnd

Excel VBA extract table from website

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Web browsers are applications used primarily to display documents, files and media from the Internet, identified by a Uniform Resource Identifier (URI) that can be a page, image, video or other file. Some browsers require the use of add-ons or extensions to safely render the information they receive; others have systems built into them to perform the same functions.

Web Browsers

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.