Try set the reference to Microsoft Scripting Runtime.

While you are in VBE,

[Tools] - [References] tick [Microsoft Scripting Runtime] - [OK]