Maybe you should explore using PERL. It can automate Excel I believe. Or
compile your PERL code into a dll and have limited code vba call out to that.


--
Regards,
Tom Ogilvy


" wrote:

Hey MS people, you really ought to include a better language for
scripting Office than VBA. I'm sick of typing 'End If'.

May I recommend PERL?

It's really amazing how fast you can code something up in that
language. The built in hastables and easy to use array just make it so
sweet to zip through data manipulation and the pattern matching stuff
makes text manipulation really easy.