Hey guys,
Total newb here, so sorry in advance.
I mashed together a couple VBA scripts on my Windows 7 system running Excel 2007. They work great! But I now need them to work on a Mac running Excel 2011. I transferred the file and changed the folder locations as best I could. When I try to run the functions I get an error:

"MICROSOFT VISUAL BASIC :: License information for this component not found. You do not have an appropriate license to use this functionality in the design environment."


When I step through the first function I get a different error (at line 8 "Set dirObj...") :

"RUN-TIME ERROR '429': ActiveX component can't create object"


This is the code I am using on the Mac: 

Please Login or Register  to view this content.
I did a bunch of searching on the forums but can't pin down the problem. I tried changing the format of the folder paths and messing around with the references. I read that activeX isn't supported on Mac so maybe that's causing the problem?
Any help is greatly appreciated. This place has been wildly helpful for me, cheers!