GetOpenFilename - Excel 2003 vs 2010

I've been given a project to test macros to see if they will function in both Excel 2003 and 2010. I came across one workbook where I found a slight difference when using Excel 2010.

Please Login or Register  to view this content.

When using this code, I was tasked with seeing if in the Confirm Message Box the 2 selected files could accidentally be selected incorrectly and be correctly displayed. I wanted to see if the selected file for File_Text would show up under File_dRn and vice a versa.

When I ran the macro in Excel 2010, no matter what order I selected the files (File_Text first or second or File_dRn first or second), GetFiles(2) would always be assigned to File_Text and GetFiles(1) would always be assigned to File_dRn. I could never have this reversed.

Is there something different between Excel 2003 and 2010 that would explain what is going on?

Thank you for the help.

Thank you for the quick response back. I do understand that the code does state that each file will be assigned to a specific variable. With my testing there were 2 different scenarios being tested:

1. File_Text = GetFiles(2)
File_dRn = GetFiles(1)

2. File_Text = GetFiles(1)
File_dRn = GetFiles(2)

When I ran the code for scenario #1, everything worked fine. It was expected to show the correct Confirm message box. However, when I ran the code for scenario #2, the Confirm message box display was not expected. The message box had reversed the files selected. So, File_Text = GetFiles(1) became GetFiles(2) and File_dRn = GetFiles(2) became GetFiles(1).

I had a couple other people try to run the code and they all had the same response. I guess what I am asking is if Excel 2010 has a built-in feature that if a code is run multiple times with the same files being selected in the same order, it will recognize this and correct any errors in the file selection?