No, removing my is not the way to go at all. Always use strict;, clear away all errors and then see what happens.
| [reply] [d/l] [select] |
I cant declare workbook as my as i need to use it in other subs too
| [reply] |
Then, at least, declare it as a globel variable, ie outside of all subs. Or, better, pass it as a parameter into the subs, that need it.
| [reply] |
Spreadsheet::WriteExcel tries to close your workbook automatically but sometimes has problems "If the new(), add_worksheet() or add_format() methods are called in subroutines." You can read the section on the close() method for more detail on limitations of automatic closing.
| [reply] |