View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Nigel Nigel is offline
external usenet poster
 
Posts: 923
Default Multiple File Select

Add an array declaration and Multiselect parameter to enable multiple
selections that fills the array with the selected files.....

Dim Fname()
Fname = Application.GetOpenFilename _
(filefilter:="Text Files(*.txt),*.txt,All Files (*.*),*.*",
MultiSelect:=True)




--
Cheers
Nigel



"TheIrishThug"
wrote in message
...

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