VBA prob-GetOpenFilename with multiselect=true returns string
 

I need a GetOpenFilename function with MultiSelect=True to return a
array with the selected files' paths (wich is the correct behavior o
the function).
But, sometimes it returns just a string with the first selected fil
path.
This seems to happen when another wksheet in the same folder as the on
selected with the function is already open. I'm using Excel 97.
This is really getting on my nerves... Thanks for the help

--
Message posted from http://www.ExcelForum.com

VBA prob-GetOpenFilename with multiselect=true returns string
 

I am having the same problem. Excel does not return an array if a single
file is selected. Also, for some users only 1 file is returned even when the
user selects multiple files. We are running on Excel 2003.

"felze84 " wrote:

I need a GetOpenFilename function with MultiSelect=True to return an
array with the selected files' paths (wich is the correct behavior of
the function).
But, sometimes it returns just a string with the first selected file
path.
This seems to happen when another wksheet in the same folder as the one
selected with the function is already open. I'm using Excel 97.
This is really getting on my nerves... Thanks for the help!


---
Message posted from http://www.ExcelForum.com/