Thread: GetOpenFilaName
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
אלי אלי is offline
external usenet poster
 
Posts: 67
Default GetOpenFilaName

Hi all!

I am using the Application.GetOpenFilaName procedure in order the get the
path of files. if it is in a MultiSelect mode the pathes are an array. I
tried to copy them to a worksheet but i got only the last path. Is it posible
to get all the pathes each one in a separate cell?

FileName = Application.GetOpenFilename(FileFilter:="Text File
(*.txt),*.txt", MultiSelect:=True)
Range("A1").Value = FileName

Thanks in advance

Eli