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

MacID VBA
 

I got it in a book. I found xlTextMac, xlCSVMac as the only Mac specific
ones. It should be in the VB Help under fileformat property.

" wrote:

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

MacID VBA
 

Oh, sorry I forgot to put the numbers. Is that what you mean by ID's?
xlCSV = 6
xlTextMac = 19

" wrote:

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