perl and VB

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

Replies are listed 'Best First'.
Re: perl and VB by osfameron (Hermit) on Aug 01, 2002 at 10:35 UTC
I posted an example of how to incorporate some Perl into a VBA function in Excel. This is probably similar in VB/VB Script. As to the other way round: Inline::VB anyone? (Actually, I think a monk wrote a VB to Perl translator, but I don't have time to super search for it just now). Cheerio! Osfameron http://osfameron.perlmonk.org/chickenman/	[reply]
Re: perl and VB by Basilides (Friar) on Aug 01, 2002 at 11:08 UTC
I sometimes run Perl out of VBA in Excel To call your Perl routine, you want something like this in your VBA: `ChDir "C:\PerlWork\" a = Shell("command.com /c perl myprog.pl -w")` [download] HTH, Dennis	[reply] [d/l]
Re: perl and VB by CubicSpline (Friar) on Aug 01, 2002 at 13:14 UTC
Not sure if you're meaning a "visual basic" script (they're exes) or if you're meaning run a "vbscript". Either way, you could run either from within Perl using the `system()` call. Examples: `$return_code = system("MyVBProgram.exe"); #VB complied program` `$return_code = system("cscript MyVBScript.vbs"); #VBScript` ~CubicSpline "No one tosses a Dwarf!"	[reply] [d/l] [select]