Re: Please help me pass an array from VBA to Perl and populate it. Newbie at wits' end!

david.f.jenkins@xxxxxxx schreef:

I'm aware of that.

Of what? Don't top-post.


I have created the Perl ActiveX control I need, and can safely travel
back and forth from VBA to Perl. What I *need* is help on the
mechanics of getting String array information back from the called
control. I am unable to figure out how to do this either through a
passed argument, or through VBA access of the control's poperties.

Right now, I'm pretty much dead in the water. I just can't believe
that this is not a problem that myriads of others have already faced
and overcome.


Maybe this helps:

SOAP::Lite
http://search.cpan.org/src/BYRNE/SOAP-Lite-0.69/examples/COM/
("when you return an array reference from a subroutine, it is
automatically converted into an array in the host language")

Scriptlets
http://www.foo.be/docs/tpj/issues/vol3_4/tpj0304-0009.html

PDK:
http://www.foo.be/docs/tpj/issues/vol5_3/tpj0503-0011.html

(all from the first few hits of google: vba perl string return)

--
Affijn, Ruud

"Gewoon is een tijger."


.

Relevant Pages

  • Re: Please help me pass an array from VBA to Perl and populate it. Newbie at wits end!
    ... I want to pass an empty container for a set of strings from VBA into ... Perl, do some stuff in Perl, and populate the Collection with a set of ... I operatoe on it in Perl as an array? ... Do I have to populate my own Perl array and then do something ...
    (comp.lang.perl.misc)
  • Re: Please help me pass an array from VBA to Perl and populate it. Newbie at wits end!
    ... I want to pass an empty container for a set of strings from VBA into ... Perl, do some stuff in Perl, and populate the Collection with a set of ... I operatoe on it in Perl as an array? ... Do I have to populate my own Perl array and then do something ...
    (comp.lang.perl.misc)
  • Please help me pass an array from VBA to Perl and populate it. Newbie at wits end!
    ... I want to pass an empty container for a set of strings from VBA into ... Perl, do some stuff in Perl, and populate the Collection with a set of ... I operatoe on it in Perl as an array? ... Do I have to populate my own Perl array and then do something ...
    (comp.lang.perl.misc)
  • Re: Record parsing
    ... Think I'll go home and crack open Perl for Dummies, ... The logic in VBA will be pretty much the same as in Perl, ... > @first is an array (like a VBA variant array, ... > ne translates as ...
    (microsoft.public.access.modulesdaovba)
  • Re: Learning Perl
    ... it should be an array, ... Then they'd be completely inaccessible to beginners. ... that should be my $var. ... so why is it redundant to point out that Perl is different from C here? ...
    (comp.lang.perl.misc)