Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 587
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
LoadPicture workaround for Excel 2011 VBA for Mac [email protected] Excel Programming 0 May 15th 12 12:37 AM
Excel 2011 for Mac tries to run a file when it starts up Drew[_12_] Excel Programming 0 August 21st 11 11:54 AM
LoadPicture command for excel 2011 for Mac Andrew Bourke Excel Programming 0 May 26th 11 12:00 AM
Dotted Border Quality in Excel:Mac 2011 Excel_Lent Excel Discussion (Misc queries) 0 February 9th 11 07:24 PM
Migration to Excel:Mac 2011, but what about the VBA projects? Michael Mueller[_2_] Excel Programming 3 December 31st 10 08:45 PM


All times are GMT +1. The time now is 09:51 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"