Dir function on Excel 2011 for Mac

Discussion in 'Excel Programming' started by watergate74, Nov 3, 2012.

  1. watergate74

    watergate74 Guest


    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.

    watergate74, Nov 3, 2012
    1. Advertisements

  2. watergate74

    isabelle Guest


    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"))
    isabelle, Nov 3, 2012
    1. Advertisements

  3. watergate74


    Jun 23, 2014
    Likes Received:
    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, Jun 26, 2014
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.