Dir function on Excel 2011 for Mac

[watergate74]

Hello,

I'm trying to write a script which returns all files and folders of a certain folder? This works fine on my Windoes pc but goes wrong on my broths Mac computer. Does anybody have an idea how to program this?

Thank you in advance.

watergate

 

[isabelle]

hi,


In Microsoft Windows, The Dir function lets you use wildcards or
wildcards (* or?) To select multiple files.
On the Macintosh, these characters are considered characters valid file
names and can not be used as wildcards to specify multiple files.

Since the Macintosh does not support wildcards, use the file type to
identify groups of files.
You can use MacID to indicate the file type instead of file names. For
example, the following statement returns the name of the first TEXT file
in the current directory:

Dir ("Path", MacID ("TEXT"))

 

[BobJordanB]

But be careful. For example an Excel file created on Mac will get a MacID of "XLSX".
The identical file created on a PC and then moved to a Mac will have a MacID of ""

I found out the hard way

BobJordanB