+ Reply to Thread
Results 1 to 6 of 6

Want to Learn Dic = CreateObject("scripting.dictionary") & Dic.CompareMode = vbTextCompare

  1. 09-10-2014, 01:33 PM #1
    rr1050
    rr1050 is offline
    Forum Contributor
    Join Date
    12-27-2008
    Location
    India
    MS-Off Ver
    Office 365
    Posts
    237

    Want to Learn Dic = CreateObject("scripting.dictionary") & Dic.CompareMode = vbTextCompare

    Hi,

    Today's my thread about to learn following,

    Please Login or Register  to view this content.
    What is dic as object? What mean scripting directory? where they are used? & next may be different function like Dic.CompareMode = vbTextCompare; what is this?

    Can any one share thoughts/ comments or share links where possible to learn scripting.dictionary in details?

    Regards, RL
    Last edited by Leith Ross; 09-10-2014 at 01:36 PM. Reason: Added Code Tags
    Reply With QuoteRegister To Reply
  2. 09-10-2014, 01:39 PM #2
    AB33
    AB33 is offline
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Want to Learn Dic = CreateObject("scripting.dictionary") & Dic.CompareMode = vbTextCom

    Why is a work sheet or workbook an object? will answer Q1.
    Dic.CompareMode = vbTextCompare
    means the dic object is case insensitive (vbTextCompare)
    Try to goggle it
    Reply With QuoteRegister To Reply
  3. 09-10-2014, 01:47 PM #3
    HaHoBe
    HaHoBe is offline
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 365 on Win11 (desktop), 2019 on Win11 (notebook)
    Posts
    8,198

    Re: Want to Learn Dic = CreateObject("scripting.dictionary") & Dic.CompareMode = vbTextCom

    Hi, rr1050,

    Dim Dic As Object
    used for Late Binding, no reference in Excel VBE must be set to Library holding that Object, and the Object may be used with different versions of the Library (Libraries will upgrade but fail to downgrade, especially if you wortk with different versions of Excel).

    Dic = CreateObject("scripting.dictionary")
    It should read
    Please Login or Register  to view this content.
    Ciao,
    Holger
    Last edited by HaHoBe; 09-10-2014 at 01:51 PM.
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you
    Reply With QuoteRegister To Reply
  4. 09-10-2014, 01:49 PM #4
    rr1050
    rr1050 is offline
    Forum Contributor
    Join Date
    12-27-2008
    Location
    India
    MS-Off Ver
    Office 365
    Posts
    237

    Re: Want to Learn Dic = CreateObject("scripting.dictionary") & Dic.CompareMode = vbTextCom

    I did the google but not found too much details about "scripting.dictionary".

    would like to learn this concept... pls can you share knowledge?
    Reply With QuoteRegister To Reply
  5. 09-10-2014, 02:05 PM #5
    rr1050
    rr1050 is offline
    Forum Contributor
    Join Date
    12-27-2008
    Location
    India
    MS-Off Ver
    Office 365
    Posts
    237

    Re: Want to Learn Dic = CreateObject("scripting.dictionary") & Dic.CompareMode = vbTextCom

    Thanks, Holger

    If it is not reference to Excel VBE but usuful while making code. Pls can advise where I can learn about this?
    Reply With QuoteRegister To Reply
  6. 09-10-2014, 02:12 PM #6
    HaHoBe
    HaHoBe is offline
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 365 on Win11 (desktop), 2019 on Win11 (notebook)
    Posts
    8,198

    Re: Want to Learn Dic = CreateObject("scripting.dictionary") & Dic.CompareMode = vbTextCom

    Hi, rr1050,

    a starting point might be Dictionary Object or a google search for examples on the subject (or make out some persons who regularly use the object and follow their threads).

    Ciao,
    Holger
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] CreateObject("scripting.dictionary") Add Item Problem---->Empty Cells
    By HerryMarkowitz in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-15-2014, 05:04 PM
  2. [SOLVED] Scripting Dictionary - CompareMode only partially working...
    By Zoediak in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-27-2013, 03:40 PM
  3. [SOLVED] How to understand and use CreateObject("Scripting.Dictionary")
    By Darthzo in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 04-03-2013, 07:21 PM
  4. How to use "CreateObject("WScript.Shell").Popup" in different workbooks at the same time.
    By mario60 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-03-2013, 04:32 PM
  5. Trying to learn how to use CreateObject("VBScript.RegExp")
    By stanleydgromjr in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 09-04-2010, 08:07 PM

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1