search

Perl / perl5

🐪 The Perl programming language
https://dev.perl.org/perl5/
Other
1.98k stars 558 forks source link

Bug Report: Problem calling PerlEz from Excel VBA #5076

Closed p5pRT closed 19 years ago

p5pRT commented 22 years ago

Migrated from rt.perl.org#8581 (status was 'rejected')

Searchable as RT8581$

p5pRT commented 22 years ago

From aturkenich@yahoo.com

I have been trying to use perl from Excel VBA using PerlEz. I have found a website that had a copy of a piece of code from an article on ZdNet. The website is http​://senna.pa.msu.edu/comp/excel/perl . There is a link to load a sample excel workbook with VBA code that calls PerlEz and a text source code at http​://senna.pa.msu.edu/comp/excel/perl/perl-zdnet-example.txt and http​://senna.pa.msu.edu/comp/excel/perl/perl-zdnet-test.txt

I have loaded these but could not make them work. I ketp getting "No handle to Perl" error.

I have read in the Activestate mailing list archives (both activeperl and perl-win32-users lists) that other people have been having the same problem with activestate releases past 522.

Some one suggested missing PerlCRT file in releases past 522 (see Robert Thorpe message of 12/18/2001 in activeperl list) is the cause of the problem.

Alex Turkenich

Perl Info ``` Flags: category=core severity=critical Site configuration information for perl v5.6.1: Summary of my perl5 (revision 5 version 6 subversion 1) configuration: Platform: osname=MSWin32, osvers=4.0, archname=MSWin32-x86-multi-thread uname='' config_args='undef' hint=recommended, useposix=true, d_sigaction=undef usethreads=undef use5005threads=undef useithreads=define usemultiplicity=define useperlio=undef d_sfio=undef uselargefiles=undef usesocks=undef use64bitint=undef use64bitall=undef uselongdouble=undef Compiler: cc='cl', ccflags ='-nologo -O1 -MD -DNDEBUG -DWIN32 -D_CONSOLE -DNO_STRICT -DHAVE_DES_FCRYPT -DPERL_IMPLICIT_CONTEXT -DPERL_IMPLICIT_SYS -DPERL_MSVCRT_READFIX', optimize='-O1 -MD -DNDEBUG', cppflags='-DWIN32' ccversion='', gccversion='', gccosandvers='' intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=1234 d_longlong=undef, longlongsize=8, d_longdbl=define, longdblsize=10 ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t', lseeksize=4 alignbytes=8, usemymalloc=n, prototype=define Linker and Libraries: ld='link', ldflags ='-nologo -nodefaultlib -release -libpath:"C:\Perl\lib\CORE" -machine:x86' libpth="C:\Perl\lib\CORE" libs= oldnames.lib kernel32.lib user32.lib gdi32.lib winspool.lib comdlg32.lib advapi32.lib shell32.lib ole32.lib oleaut32.lib netapi32.lib uuid.lib wsock32.lib mpr.lib winmm.lib version.lib odbc32.lib odbccp32.lib msvcrt.lib perllibs= oldnames.lib kernel32.lib user32.lib gdi32.lib winspool.lib comdlg32.lib advapi32.lib shell32.lib ole32.lib oleaut32.lib netapi32.lib uuid.lib wsock32.lib mpr.lib winmm.lib version.lib odbc32.lib odbccp32.lib msvcrt.lib libc=msvcrt.lib, so=dll, useshrplib=yes, libperl=perl56.lib Dynamic Linking: dlsrc=dl_win32.xs, dlext=dll, d_dlsymun=undef, ccdlflags=' ' cccdlflags=' ', lddlflags='-dll -nologo -nodefaultlib -release -libpath:"C:\Perl\lib\CORE" -machine:x86' Locally applied patches: ACTIVEPERL_LOCAL_PATCHES_ENTRY @INC for perl v5.6.1: C:/Perl/lib C:/Perl/site/lib . Environment for perl v5.6.1: HOME (unset) LANG (unset) LANGUAGE (unset) LD_LIBRARY_PATH (unset) LOGDIR (unset) PATH=C:\Python21\;C:\WINDOWS\system32;C:\Perl\bin;C:\WINDOWS;C:\WINDOWS\COMMAND;C:\WINDOWS\system32\WBEM;C:\Program Files\Executive Software\DiskeeperWorkstation\;C:\PROGRA~1\vtk40\bin PERL_BADLANG (unset) SHELL (unset) __________________________________________________ Do You Yahoo!? Yahoo! Sports - Coverage of the 2002 Olympic Games http://sports.yahoo.com ```
p5pRT commented 19 years ago

From @smpeters

[aturkenich@​yahoo.com - Mon Feb 18 06​:02​:49 2002]​:

This is a bug report for perl from aturkenich@​yahoo.com\, generated with the help of perlbug 1.33 running under perl v5.6.1.

----------------------------------------------------------------- [Please enter your report here]

I have been trying to use perl from Excel VBA using PerlEz. I have found a website that had a copy of a piece of code from an article on ZdNet. The website is http​://senna.pa.msu.edu/comp/excel/perl . There is a link to load a sample excel workbook with VBA code that calls PerlEz and a text source code at http​://senna.pa.msu.edu/comp/excel/perl/perl-zdnet-example.txt and http​://senna.pa.msu.edu/comp/excel/perl/perl-zdnet-test.txt

I have loaded these but could not make them work. I ketp getting "No handle to Perl" error.

I have read in the Activestate mailing list archives (both activeperl and perl-win32-users lists) that other people have been having the same problem with activestate releases past 522.

Some one suggested missing PerlCRT file in releases past 522 (see Robert Thorpe message of 12/18/2001 in activeperl list) is the cause of the problem.

Alex Turkenich

PerlEz is a product of ActiveState. I would suggest opening a ticket directly to ActiveState.

p5pRT commented 19 years ago

@smpeters - Status changed from 'open' to 'rejected'