View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
robotman robotman is offline
external usenet poster
 
Posts: 51
Default Get user-picked list of file names on Mac?

Thanks for the reply, John.

I saw that the filter syntax is "TEXT" instead of ".txt", but the Help
doesn't list what are other acceptable Mac filters (i.e. "EXCEL",
"OFFICE"?). Also, can you pass any other parameters to the
GetOpenFileName() method on the Mac? The help file is a bit lean with
Mac info!

I can't use a conditionally-compiled user form because the user needs
to browse for the folder and then select the files. For now, I'm
conditionally having the macro ask the user to choose files one-by-one
on the Mac which is a bit tedious.

Hmmm... let me know if you can think of anything else. Maybe have the
user pick the folder and then pop-up the conditionally-compiled form?

Thanks!

John