in reply to
Parsing multiple excel files in perl
Seeing the codes you posted I guess your problem is really with design rather then with Perl itself. Codes posted are not complete, so I assume you face following:
You have GUI application, in which after pressing some button 'Open file' dialog is displayed, where you choose file to be opened, then subroutine (which you pasted) is run in order to do stuff with this file. Am I correct that your problem is that you don't know how to allow user choosing more than one file from dialog box? And another thing is how to pass result of this dialog box to subroutine in order to open more files?
This kind of information is what we need. If you answer yes to those questions, then you should consider following two approaches (I don't know API of GUI you use and don't know if it allows such operations): 'open file' dialog window should allow user to choose more than one file (standard way on Windows is with Ctrl key) or you should open 'open file' dialog window in the loop as many times as there are files to be processed.
So if you were able to present following code of your GUI:
$window->create("my main window");
$window->addbutton(somex, somey, somewidth, someheight, name, \&mysub)
my $result = $window->openFileDialog(...);
# error check
open FH "$result" or die $!;
# parsing file
you could get proper help from us. Of course in case my assumptions are correct.