Anonymous

I've got these machine that output a lot of data. Unfortunately, the files outputted are structured in a strange way. I'd like to be able to do some complex text processing (perl style) to parse the data and be able to output to Excel format. I'd also like to automate this but the only server that I can use is running Windows XP (with Office) and I'm not allowed to install any extraneous software (no .NET, Powershell, ActivePerl, etc.)
What is the best way to do this? Are regex in VB/VBA powerful enough for me to script in Excel?

>>6
Of course. I'm fooling around with it now. Does strawberry perl support all the CPAN modules that regular perl supports? (like Win32::OLE and Spreadsheet::WriteExcel)