topic Re: reference for 'External References' and Namespace Imports -- Vb Macro in Product Forum

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

spalkar1 — Wed, 21 Feb 2024 17:28:37 GMT

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

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

harish.mogulluri — Wed, 21 Feb 2024 17:42:19 GMT

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

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

spalkar1 — Wed, 21 Feb 2024 20:06:49 GMT

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