replacing VB with perl in excel

jsPerl has asked for the wisdom of the Perl Monks concerning the following question:

I have a rather complicated excel spreadheet and want to get out of VB and use perl exclusively. I can do most of what I want, but can't figure out how to handle control buttons. If I can't handle these buttons explicitly, is there a way to call a perl script (or subroutine) from within a VB macro, such as cmdButton.click?

Comment on replacing VB with perl in excel

Replies are listed 'Best First'.
Re: replacing VB with perl in excel by marto (Cardinal) on Jun 29, 2007 at 17:54 UTC
Hi jsPerl, You may also be interested in How to convert a VBA macro to Perl, which I have mentioned a few times in response to Excel questions. Hope this helps Martin	[reply]
Re: replacing VB with perl in excel by traveler (Parson) on Jun 29, 2007 at 17:31 UTC
Super Search helped me find a similar topic that should point you in the right direction.	[reply]

Back to Seekers of Perl Wisdom