Results 1 to 3 of 3
  1. #1
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Scripting.Dictionary (VBA/Word-Excel/2003)

    What advantages/disadvantages are associated with using Scripting.Dictionary instead of an array?
    Regards
    Don

  2. #2
    Plutonium Lounger
    Join Date
    Nov 2001
    Posts
    10,550
    Thanks
    0
    Thanked 7 Times in 7 Posts

    Re: Scripting.Dictionary (VBA/Word-Excel/2003)

    <post:=446,450>post 446,450</post:> describes the advantages of a dictionary over a collection.

    StuartR

  3. #3
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Scripting.Dictionary (VBA/Word-Excel/2003)

    A Collection or Dictionary is useful where you want to create your own keys rather than using an array's simple numeric indexing. For example, myData("Address") rather than myData(3). If you do not need to create your own keys, it's easier to use an array.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •