LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
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





 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Setting up a list where an item can only be picked once in Excel J. Excel Worksheet Functions 2 May 17th 07 01:17 AM
VBA code to list names of controls on user form? Peter[_59_] Excel Programming 3 July 31st 06 09:33 AM
For each picked entitiy in a list box... Ctech[_115_] Excel Programming 8 March 21st 06 05:28 PM
How validation dropdown list open when cell is picked?. ron Excel Worksheet Functions 1 February 22nd 06 12:44 AM
How to disable a button picked from the Forms list. Ben Excel Programming 3 November 28th 05 08:29 PM


All times are GMT +1. The time now is 12:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"