reference for 'External References' and Namespace Imports -- Vb Macro

[spalkar1]

Hi,

 I wrote a code macro using the VB Dictionary Object. But I do not know which corresponding dll to include in the External references and as well what to write in Namespace imports.

What document / source can I refer to find out this and other VB objects that are available to be used in the Code ?

Error : Compiler error, Type Dictionary is not defined

[harish.mogulluri]

Hi Surabh Palkar,

Check below articles, Looks like you need to include (Microsoft Scripting Runtime) in your reference.

https://www.vbforums.com/showthread.php?538998-Can-t-create-dictionary-in-Excel-VBA
https://stackoverflow.com/questions/46128010/dim-as-dictionary-compile-error-user-defined-type-not-defined

[spalkar1]

 I was able to resolve this by using fully qualified names as this... and then it worked...Dim a_Dict As System.Collections.Generic.Dictionary