+ Reply to Thread
Results 1 to 3 of 3

Trouble using Create object("scripting.dictionary") with mac

  1. #1
    Registered User
    Join Date
    09-01-2020
    Location
    Chile
    MS-Off Ver
    O365
    Posts
    1

    Question Trouble using Create object("scripting.dictionary") with mac

    What can I use, instead of this script ? ... It's a Macros created in excel for windows and I did open it with a mac.

    Sub idequifax()

    Debug.Print "Start Dict"
    Dim Dict As Object
    'Crear
    Set Dict = CreateObject("Scripting.Dictionary")

    fila = 2
    Do While Worksheets(2).Cells(fila, 1).Value <> ""
    If Dict.Exists(Worksheets(2).Cells(fila, 1).Value) Then
    Dict(Worksheets(2).Cells(fila, 1).Value) = Dict(Worksheets(2).Cells(fila, 24).Value)
    Else
    Dict.Add Key:=Worksheets(2).Cells(fila, 1).Value, Item:=Worksheets(2).Cells(fila, 24)
    End If
    fila = fila + 1
    Loop

    Debug.Print "End Dict"

    Final = 2
    Do While Worksheets(1).Cells(Final, 1).Value <> ""
    Worksheets(1).Cells(Final, 24).Value = Dict(Worksheets(1).Cells(Final, 1).Value)
    Final = Final + 1
    Loop


    End Sub


    Many thanks !

  2. #2
    Forum Contributor Dante Amor's Avatar
    Join Date
    07-24-2020
    Location
    MEXICO
    MS-Off Ver
    Excel 2013
    Posts
    212

    Re: Trouble using Create object("scripting.dictionary") with mac

    Hi and welcome to Excel Forum.

    I think your macro has a little problem, it should look like this:

    Please Login or Register  to view this content.
    ---------------------------------------------------------
    instead of this script ?
    Try this:

    Please Login or Register  to view this content.

  3. #3
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,646

    Re: Trouble using Create object("scripting.dictionary") with mac

    Have a look here.
    If posting code please use code tags, see here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] problem converting to CreateObject("Scripting.Dictionary") method
    By dschmitt in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 12-24-2015, 04:19 AM
  2. Mac excel error Runtime Error 429 due to CreateObject("Scripting.Dictionary")
    By iamstevetay in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-30-2015, 04:21 PM
  3. What is With CreateObject("Scripting.Dictionary")
    By ammartino44 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-30-2015, 01:50 PM
  4. [SOLVED] VBA "Scripting.Dictionary" Word Occurences under each category
    By manofcheese in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-23-2015, 03:37 PM
  5. Replies: 5
    Last Post: 09-10-2014, 02:12 PM
  6. [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
  7. [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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1