PDA

View Full Version : Quick question about Application.GetOpenFilename()



k13r4n
01-19-2009, 07:20 PM
I have noticed that when using Application.GetOpenFilename() to get the user to select multiple files, the last file selected is always at the top of the resultant array of file names

E.G.

If the user selects file01 to file04 you get an array that goes

File04
File01
File02
File03

Why is this?

My VBA code opens the selected files and imports some data from them into a worksheet and they have to be in the order selected. I have writen a work-around that reorders the array correctly but i was curious as to why this happens? Anyone know? :dunno