Converting VBA to mac (runtime error 429)

[Liset]

Hi all!
I'm a beginner in coding. But I managed to make a working code for windows, but when I want to convert it to Mac it gave a runtime error 429 (AvtiveX component can't create object). This is the code that gave the error:

Please Login or Register  to view this content.

The error is in the "With CreateObject("Scripting.FileSystemObject")" part. Already from google search I found out that Scripting.FileSystemObject is only supported by windows, and will never work on a Mac. But I don't know how to fix it. Hope you can help me!

Kind regards

[Kyle123]

You can't use windows libraries on a mac (pretty much anything that requires you to set a reference or use CreateObject).

I think Dir should work though, so you can use that to check if something exists - also mkDir for creating folders

[Liset]

But do I only change the part of CreateObject("Scripting.FileSystemObject") with the Dir function? Or should I adjust the whole thing?
I already read about the Dir function, but didn't know how to implement it....

[Kyle123]

I think this should be cross platform, but it's untested:

Please Login or Register  to view this content.

[Liset]

Thanks for helping me out!
In the line of If not Len(Dir(stpath...) the error 68 occurs (device unavailable).

Is it needed to define vbDirectory?

[Kyle123]

Does Dir with the file path work? Remember that macs don't use the same path separators as windows

[Liset]

If I put it this way it still can't find its path

Please Login or Register  to view this content.

[Liset]

Please Login or Register  to view this content.

This still gives the error of unavailable device... Good thing, it can find its path! Is something like MacID a solution?

[Liset]

Still a little bit desperate on the problem over here. I think that it may be caused by an empty folder, but how can I avoid this error then? Hope you can help me out!