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

I'm just idly curious about something. I've been doing a lot of VBA work right now, for some stupid reason. A coworker suggested (in response to my whinging about said work) that I should code up a Perl to VBA conversion script.

That set me to thinking. If I think about it, someone else much smarter (and more motivated) must have already. The only thing is, I don't know what the standard for calling said module would be.

Any thoughts?

------
We are the carpenters and bricklayers of the Information Age.

Don't go borrowing trouble. For programmers, this means Worry only about what you need to implement.

Replies are listed 'Best First'.
Re: Perl to VB conversion
by tadman (Prior) on Jan 24, 2002 at 23:22 UTC
    Theoretically, VB can do just as much as Perl, but it would take a lot of code to reimplement Perl functionality in VB. Unless your idea of fun is making tinker toy computers, then you would probably want to think of something else to do.

    Writing a VB to Perl module would be difficult enough. Perl to VB is virtually impossible.
[reply]
      Actually a rudimentary VB to Perl wouldnt be that tough. (I worked on it a bit and there is some stuff on CPAN.) But id say a Perl to VB would be practically impossible.

      Yves / DeMerphq
      --
      When to use Prototypes?

[reply]
Re: Perl to VB conversion
by screamingeagle (Curate) on Jan 24, 2002 at 23:59 UTC
    if u want to use Perl as much as possible, then i would suggest using the Win32::OLE module. but you'd still have to use VBA specific functions...but look at the bright side...at least you'd be calling them from Perl :)
[reply]
Re: Perl to VB conversion
by hopes (Friar) on Jan 25, 2002 at 05:14 UTC
    You can try also to use visualperl for .net (Activestate); or use PerlCtrl to make dlls which can be used in VBA

    Hopes 
    $_=$,=q,\,@4O,,s,^$,$\,,s,s,^,b9,s,
$_^=q,$\^-]!,,print

    [download]
[reply]
[d/l]

Back to Seekers of Perl Wisdom