Dashboard > Public Content > Home > ExcelVBA
  Public Content Log In   View a printable version of the current page.  
  ExcelVBA
Added by James Richardson, last edited by James Richardson on Nov 12, 2007  (view change)
Labels: 
(None)

Some Excel VBA Useful things

Excel Object Model

Check A Named Range Exists
Custom Formulas Return an Array

Web Servicey

Get or Post to a URL

You will need to add MSXML references to the project

XML Related

Get An XML Node
Get An XPath
Create Some XML
Get An XSL Processor
Convert HTML Table Into An Array Formula Result

Check A Named Range Exists (Public Content)
Convert HTML Table Into An Array Formula Result (Public Content)
Create Some XML (Public Content)
Custom Formulas Return an Array (Public Content)
Get An XML Node (Public Content)
Get An XPath (Public Content)
Get An XSL Processor (Public Content)
Get or Post to a URL (Public Content)
Powered by Atlassian Confluence, the Enterprise Wiki. (Version: 2.5.1 Build:#806 May 06, 2007) - Bug/feature request - Contact Administrators