title: VBA (Excel) Dictionary on Mac?
body: <p>I have an Excel VBA project that makes heavy use of Windows Scripting <a href="http://msdn.microsoft.com/en-us/library/x4k5wbx4%28v=vs.84%29.aspx">Dictionary</a> objects. I recently had a user attempt to use it on a Mac and received the following error:</p>
  
  <pre><code>Compile Error: Can't find project or library
  </code></pre>
  
  <p>Which is the result of using the <code>Tools &gt; References &gt; Microsoft Scripting Runtime</code> library.</p>
  
  <p>My question is, <strong><em>is there a way to make this work on a Mac</em></strong>?</p>
  
  <p>The following are the 3 cases I can think of as being possible solutions:</p>
  
  <ol>
  <li>Use a Mac plugin that enables use of Dictionaries on Macs (<em>my favorite option if one exists</em>)</li>
  <li><p>Do some kind of variable switch like the following:</p>
  
  <pre><code>isMac = CheckIfMac
  If isMac Then
      ' Change dictionary variable to some other data type that is Mac friendly and provides the same functionality 
  End If
  </code></pre></li>
  <li><p>Write 2 completely separate routines to do the same thing (<em>please let this not be what needs to happen</em>):</p>
  
  <pre><code>isMac = CheckIfMac
  If isMac Then
      DoTheMacRoutine
  Else
     DoTheWindowsRoutine
  End If
  </code></pre></li>
  </ol>