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
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