Hi, > I still haven't worked out how to check for macros yet but the text has been > sorted
I think you can find out how to handle embeded macros is to produce a excelsheet, record a macro and save the whole as a new excelfile. I don't know if the vba-code is stored as a binarypart in the file. But I think by parsing the file with the Excelparser you can find it out. In other fact try to parse the file as normal textfile and look if there is some other data that is not worksheetcode that defines the cells. > #!/usr/bin/perl > > use strict; > use warnings; > use Text::Extract::Word; > use Spreadsheet::ParseExcel; > use Spreadsheet::ParseXLSX; > use File::Basename; ... Regard, Ruprecht Web: http://www.rheyn.de -- To unsubscribe, e-mail: beginners-unsubscr...@perl.org For additional commands, e-mail: beginners-h...@perl.org http://learn.perl.org/
