cancel
Showing results for 
Search instead for 
Did you mean: 

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

SaurabhPalkar1
Level 3

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

2 REPLIES 2

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

-----------------------
If I answered your query. Please mark it as the Best Answer

Harish Mogulluri

SaurabhPalkar1
Level 3

 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