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?

Thank you, I've already written a few text-parsing scripts in perl and this is very convenient. However, I don't know if IT will appreciate the 55MB size.