CreateObject("Scripting.FileSystemObject") doesn't work under Excel for Mac [duplicate]

Question

I have a piece of VBA code which is used to get subfolders given a path, it works well under Excel for Windows:

Function GetSubFolders(RootPath As String)
    Dim fso As Object
    Dim fld As Object
    Dim sf As Object
    Dim myArr

    Set fso = CreateObject("Scripting.FileSystemObject")
    Set fld = fso.GetFolder(RootPath)
    For Each sf In fld.SUBFOLDERS
        Counter = Counter + 1
        ReDim Preserve Arr(Counter)
        Arr(Counter) = sf.Path
        myArr = GetSubFolders(sf.Path)
    Next
    GetSubFolders = Arr
    Set sf = Nothing
    Set fld = Nothing
    Set fso = Nothing
End Function

Now I would like to run this code under Excel for Mac (version: 2011 14.4.1). It gives an error at the line Set fso = CreateObject("Scripting.FileSystemObject"). The error message is Run-time error '429': ActiveX component can't create object.

Could anyone help me debug it?

Community · Accepted Answer · 2017-05-23 12:05:10Z

3

The FileSystemObject is part of the Windows scripting library, which doesn't exist on Mac OSX.

Similar question asked previously: How can I install/use "Scripting.FileSystemObject" in Excel 2010 for MAC?

edited May 23, 2017 at 12:05

CommunityBot

11 silver badge

answered May 3, 2014 at 19:13

citizenkong

6895 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

RubberDuck Over a year ago

Please see this meta question about duplicates. Duplicates should be flagged as such.

Collectives™ on Stack Overflow

CreateObject("Scripting.FileSystemObject") doesn't work under Excel for Mac [duplicate]

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related