How can I install/use "Scripting.FileSystemObject" in Excel 2010 for MAC?

Question

I am using Excel for Mac 2011 which has VBA version 14.0.

I am trying to use this code which accesses the file system, which I know works on Windows:

Function qfil_GetDirectory(strDirectoryName As String)

    Dim objFSO As Variant
    Dim objDirectory As Variant

    Set objFSO = CreateObject("Scripting.FileSystemObject")
    Set objDirectory = objFSO.GetFolder(strDirectoryName)
    Set qfil_GetDirectory = objDirectory

End Function

However, when I run it in Excel for Mac 2011, it gives me this error:

Run-time error 429 Object creation with ActiveX component not possible

To fix this on Windows, I know I have to just reference a specific DLL under tools.

However on the Mac, when I go under tools | references it only gives me these:

alt text

And none of them allow me to use Scripting.FileSystemObject.

What do I have to do in Excel 2011 for Mac so that I can use Scripting.FileSystemObject to read files from the hard drive from an Excel sheet via VBA?

trickwallett · Accepted Answer · 2011-01-12 15:37:34Z

2

To my knowledge, this approach won't be valid on Mac, as the external library doesnt exist.

Don't know Office 11 VBA, but the Dir() function works accross platforms for '03.

answered Jan 12, 2011 at 15:37

trickwallett

2,45817 silver badges16 bronze badges

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

Comments

kksf · Accepted Answer · 2013-12-09 17:43:20Z

2

What about...? Writing mac compatible file i o code in vba

answered Dec 9, 2013 at 17:43

kksf

751 gold badge2 silver badges10 bronze badges

Comments

Ken White · Accepted Answer · 2011-01-12 16:17:18Z

0

Mac doesn't support ActiveX (it's a Windows technology), so you can't create the Scripting.FileSystemObject; it doesn't exist. (Even if it did, it's based on FAT32 or NTFS file systems, so it wouldn't work on OS X anyway.)

answered Jan 12, 2011 at 16:17

Ken White

126k15 gold badges237 silver badges476 bronze badges

Comments

Siddharth Rout · Accepted Answer · 2012-06-06 02:04:43Z

0

If you're just trying to enumerate all the files in a folder, Codematic have a pretty good VBA module which should work fine on the Mac. It's not free, though.

edited Jun 6, 2012 at 2:04

Siddharth Rout

150k18 gold badges212 silver badges258 bronze badges

answered Jan 12, 2011 at 20:01

Chris Rae

5,6752 gold badges40 silver badges54 bronze badges

Collectives™ on Stack Overflow

How can I install/use "Scripting.FileSystemObject" in Excel 2010 for MAC?

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related