The documentation for Excel::Writer::XLSX shows 5 different examples for setting the filename via new(). If that doesn't help, please show your code.

When you open a file in Perl, it gets created if it didn't already exist. I don't know what Tk has to do with this, but I assume you're displaying the spreadsheet there, somehow. If you don't want it saved just yet, do something like the following:

use Excel::Writer::XLSX;

#Create a filehandle that just points to a scalar for now.
my $excel_data = "";
open( XLS_TMP_FH, \$excel_data );

#Call the workbook constructor
my $workbook = Excel::Writer::XLSX->new( \*XLS_TMP_FH );

#...

#Chose if you want to save it
if( i_want_to_save_it() ) {
    open( XLS_FILE, ">", "myfile.xlsx" ) or die( "Cannot open file: $!
+" );
    print XLS_FILE join( "", <XLS_TMP_FH> );
    close XLS_FILE;
}
close XLS_TMP_FH;
[download]

I don't know if that will actually work(see signature :-), but it's worth a shot.

This is creating a new file and getting saved to the current directory. But I want this file to create and open in the machine instead of getting saved

The current directory is on a machine, so it works, the end