Newton Excel Bach, not (just) an Excel Blog
An Excel blog for engineers and scientists, and an engineering and science blog for Excel users.
Skip to content
  • Home
  • About Newton Excel Bach
  • Downloads
  • Downloads by category
  • Interactive Design Services
  • Python and pyxll
  • Using Array Functions and UDFs
← Python for VBA users- 7; Making Python go Faster
Converting from global to local coordinates (and vice versa) →

Dictionary link

Posted on 24/12/2013 by dougaj4

The VBA Scripting Dictionary object is very useful (examples here and here), but the documentation is poor.

This is fixed at Data Dictionary in VBA – Complete Syntax Documentation, which provides just what it says.

Share this:

  • Share on Facebook (Opens in new window) Facebook
  • Share on LinkedIn (Opens in new window) LinkedIn
  • Share on Tumblr (Opens in new window) Tumblr
  • Share on X (Opens in new window) X
Like Loading...

Related

This entry was posted in Excel, VBA and tagged documentation, Excel, scripting dictionaries, VBA. Bookmark the permalink.
← Python for VBA users- 7; Making Python go Faster
Converting from global to local coordinates (and vice versa) →

2 Responses to Dictionary link

  1. SutoCom Solutions's avatar SutoCom says:
    27/12/2013 at 10:39 pm

    Reblogged this on Sutoprise Avenue, A SutoCom Source.

    LikeLike

    Reply
  2. Pingback: Counting words in a list and dictionary links | Newton Excel Bach, not (just) an Excel Blog

Leave a comment Cancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

  • Categories

  • RSS Feed

    • RSS - Posts
    • RSS - Comments
  • Search NewtonExcelBach

  • Archives

  • Top Posts

    • Cubic Splines
    • Using LINEST for non-linear curve fitting
    • 3DFrame Ver 1.03 and Frame4 Ver 3.07
    • Frame Analysis with Excel - 3, Continuous beam or frame
    • Linking Excel to C - 2
    • About Newton Excel Bach
    • Retrieving unique values from a range or array ...
    • Lateral pile analyis with PY curves ...
    • XLDennis, the MSDN Library, and VBA rant
    • Buckling of columns with varying cross section
  • Recent Comments

    Z's avatarZ on Solving polynomials –…
    dougaj4's avatardougaj4 on Solving polynomials –…
    Z's avatarZ on Solving polynomials –…
    Z's avatarZ on Solving polynomials –…
    dougaj4's avatardougaj4 on Solving polynomials –…
    Z's avatarZ on Solving polynomials –…
    Z's avatarZ on Solving polynomials –…
    Z's avatarZ on Solving polynomials –…
    dougaj4's avatardougaj4 on Solving polynomials –…
    Z's avatarZ on Solving polynomials –…
    Z's avatarZ on Solving polynomials –…
    Passing 3D arrays to… on Dynamic array update and the @…
    Monte Carlo simulati… on py_UMom 1-05
    Scipy-statistics wit… on Transferring different data ty…
    Scipy-statistics wit… on Scipy-statistics update
  • Blogroll

    • 2toria
    • AJP Excel Information
    • Andrew’s Excel Tips
    • Arches
    • Bacon Bits
    • Best Excel Tutorials
    • Beyond Excel
    • Colin Caprani
    • Contextures Blog
    • Cosmic Horizons
    • Daily Dose of Excel
    • dataprose.org
    • Datascopic
    • Dick Moffat's Spreadsheet Blog
    • EngineerExcel
    • Excel Easy
    • Excel for Educators
    • Excel Unusual
    • ExcelGaard
    • ExcelXor
    • FastExcel
    • Grumpy Old Programmer
    • In the Dark
    • Jan Karel Pieterse
    • Jon Peltier’s Blog
    • Letters to Nature
    • Lucas Beattie
    • Math ∩ Programming
    • My Engineering World
    • Not Only Bridges
    • Online Training Hub
    • Option Explicit VBA
    • Pearson Software Consulting
    • Plus Magazine
    • Pointy Haired Dilbert
    • RAD Excel
    • Ron de Bruin
    • The Happy Pontist
    • The Ken Puls (Excelguru) Blog
    • The Math Less Traveled
    • TheSpreadsheetGuru
    • VBA Projects by Mark Kubiszyn
    • VSTO, .NET and Excel
    • xll add-in library
    • Yoursumbuddy
  • Family Links

    • Independent Bookkeeping
    • Little Pics
    • Long Lost
Newton Excel Bach, not (just) an Excel Blog
Blog at WordPress.com.
  • Comment
  • Reblog
  • Subscribe Subscribed
    • Newton Excel Bach, not (just) an Excel Blog
    • Join 279 other subscribers
    • Already have a WordPress.com account? Log in now.
    • Newton Excel Bach, not (just) an Excel Blog
    • Subscribe Subscribed
    • Sign up
    • Log in
    • Copy shortlink
    • Report this content
    • View post in Reader
    • Manage subscriptions
    • Collapse this bar
%d