VBA with Mac (excell) How do I get the creation date of a file

[eyalisr]

Hi,
can anyone tell me how to get the "creation date" of a file (of any type- not just the active excel document) that exists somewhere on the Mac Hard Disk using excel vba?
P.S.
I got help on how it is done on the PC - but it doesn't seem to be working on the mac

thanks,
Eyal

 

[dsi]

What do you have for the PC version? The VBA code is typically the same for Mac's other than the declaration of the path. For example:

'PC Path
sDataFile = "C:\Proofing\JobList.txt"

'Mac Path
sDataFile = "GUARDIAN:Desktop Folder:Proofing:JobList.txt"