View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Get user-picked list of file names on Mac?

Take a look at the GetOpenFilename() method topic in Mac XL/VBA Help -
the filefilter syntax is different.

And yes, a bug in MacXL prevents Multiple file selections. In my
applications, I have conditionally compiled a userform for multiselects
on the Mac.


In article . com,
robotman wrote:

I'm developing a cross-platform macro that needs to open several files
at once.

In Windows, I can use GetOpenFileName with the multi-select option to
get a list of chosen files in a single dialog:

ChosenFiles = Application.GetOpenFilename("XLS Files (*.xls),
*.xls", 1, "Please select XLS data files to import", , True)

On the Mac, I don't seem to be able to pass any of the parameters.
Can Macs even do multi-select?

ChosenFiles = Application.GetOpenFilename("")

Thanks!