Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dir function on Excel 2011 for Mac
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dir function on Excel 2011 for Mac
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")) -- isabelle Le 2012-11-03 10:11, watergate74 a écrit : 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LoadPicture workaround for Excel 2011 VBA for Mac | Excel Programming | |||
Excel 2011 for Mac tries to run a file when it starts up | Excel Programming | |||
LoadPicture command for excel 2011 for Mac | Excel Programming | |||
Dotted Border Quality in Excel:Mac 2011 | Excel Discussion (Misc queries) | |||
Migration to Excel:Mac 2011, but what about the VBA projects? | Excel Programming |