Prev: Validating Date-Time Ranges in a Schedule Database
Next: Problem with string comparison
From: Mark Clements on 4 Oct 2006 18:50
Dr.Ruud wrote:
> Michele Dondi schreef:
>> david.f.jenkins:
>
>>> I can't execute an external program or shove files around, because of
>>> performance implications, mostly. I need a "sub" (but one written in
>>> Perl) that I can call from VBA.
>> (Un)fortunately I don't know enough VBA (namely, no VBA at all) to
>> address your question. My naive answer would be along the lines that
>> it's not possible, period. But indeed there may be some
>> framework/technology that allows this. Hope someone will know better.
>
> VBA can call members of libraries, at least .dll.
> So if there would be a perllib.dll or such, it would be possible.
>

Perl classes can be wrapped as COM components. See Windows Script
Components.

Mark
From: Mumia W. (reading news) on 6 Oct 2006 15:27
On 10/06/2006 10:26 AM, david.f.jenkins(a)usa.net wrote:
> [...]
> Since I have *no* problem passing strings back and forth (my problem is
> arrays, remember? (See my previous posts for repeated references to
> arrays.)) I have generally seen fit to include "array" in most of my
> searching.
>

Have you considered the possibility that there is no direct way to pass
arrays between VBA and Perl?

Have you considered using Data::Dumper or Storable or FreezeThaw to
convert arrays to/from strings?

I'm tired of reading this thread. Bye bye thread.


--
paduille.4058.mumia.w(a)earthlink.net
Posting Guidelines for comp.lang.perl.misc:
http://www.augustmail.com/~tadmc/clpmisc/clpmisc_guidelines.html

From: Mumia W. (reading news) on 6 Oct 2006 16:50
On 10/06/2006 02:27 PM, Mumia W. (reading news) wrote:
> On 10/06/2006 10:26 AM, david.f.jenkins(a)usa.net wrote:
>> [...]
>> Since I have *no* problem passing strings back and forth (my problem is
>> arrays, remember? (See my previous posts for repeated references to
>> arrays.)) I have generally seen fit to include "array" in most of my
>> searching.
>>
>
> Have you considered the possibility that there is no direct way to pass
> arrays between VBA and Perl?
>
> Have you considered using Data::Dumper or Storable or FreezeThaw to
> convert arrays to/from strings?
>

Doh! Of course you can't do that. Join the element into a string and
pass that instead.

> I'm tired of reading this thread. Bye bye thread.
>
>

Doh! I had to read some more of this thread because of my own mistake :-(

--
paduille.4058.mumia.w(a)earthlink.net
Posting Guidelines for comp.lang.perl.misc:
http://www.augustmail.com/~tadmc/clpmisc/clpmisc_guidelines.html
 | 
Pages: 1
Prev: Validating Date-Time Ranges in a Schedule Database
Next: Problem with string comparison