Spread***::WriteExcel new($var) not working

Hi

I am trying to use the perl module Spread***::WriteExcel to create a
new XLS file and write into it, however in my case the name of the xls
file has to be entered by the user and it can not be fixed. So to
achieve this write something like this in my code where $XLSPath is
entered by the user before this line.

#46 my $xlsReport = Spread***::WriteExcel->new($xlsFileName);

However, I get the error
---
Can't call method "add_work***" on an undefined value at line 96 in
c:\report-xls.pl which is
---

#95 # Create new Work*** in the workbook
#96 $work*** = $xlsReport->add_work***();

I reckon this means that the variable $xlsReport is undefined which
may be because of some error in line 46. I have seen the examples and
previous question threads and do not find any example in which the
name of the file is a variable. Please help!!

Regards

Mick
.