Add a reference to Microsoft Scripting Runtime as @YowE3k said:
In the VBA Editor:
Tools -> References
Find Microsoft Scripting Runtime
Check it
Click okay