Trying to create and use a fso in an Excel 2016 macro, get error: ActiveX component can't create object (or words to that effect). Did some googling, tried to solve by referencing the Microsoft scripting library and slightly modifying the code, but no luck.
OLD WAY: Set fso = CreateObject("System.FileSystemObject")
NEW WAY: Set fso = New Scripting.FileSystemObject
Both of these get the same error message. Any ideas? (BTW, it also fails on my home PC running Excel 2013.)
Bookmarks