Thread: MacID VBA
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] passion_to_be_free@hotmail.com is offline
external usenet poster
 
Posts: 1
Default MacID VBA

I am telling my VBA subroutine to go to a directory and open all the
csv files that are inside. However, the names of the files are always
changing, and I cannot predict what they will be. From what I've read
on the Excel help files, the only way to do this on a Mac is to use
this syntax:

Dir("Macintosh HD:Users:myUser:Desktop:Folder", MacID("insertIdhere"))

The only problem is, I can't find a list of MacID's for different file
types. Does anyone know the MacID for .csv files? Does anyone know
where I can find a list of these id's?

-Benjamin