Thread: Multiple File Select
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Xcelion Xcelion is offline
external usenet poster
  
Posts: 39
Default Multiple File Select
Hi irish,
To have select more tha n one file you should give
MultiSelect :=True
GetOpenFilename(FileFilter, FilterIndex, Title, ButtonText, MultiSelect)
and it will return an array of file names selected (even when a single file
is selected)

Thanks
Xcelion


"TheIrishThug" wrote:


i know u can use the following to pass a filename.

Code:
--------------------

FName = Application.GetOpenFilename _
(filefilter:="Text Files(*.txt),*.txt,All Files (*.*),*.*")
--------------------

what i want to know can i have the user select multiple files at once?
would FName just need to be an array or would i have to do it another
way?


--
TheIrishThug
------------------------------------------------------------------------
TheIrishThug's Profile: http://www.excelforum.com/member.php...o&userid=29682
View this thread: http://www.excelforum.com/showthread...hreadid=495717


Reply With QuoteReply With Quote