First, the activestate docs that came with your distro should let you
figure out how to convert VBA calls to Perlish calls. Once you have that
down, it's a matter of learning which objects do what. For that in Word,
try:

The Office97 Programmers Guide
http://www.microsoft.com/officedev/articles/Opg/toc/pgtoc.htm

The mecca of all VBA documentation, for Office specific stuff, try:
Office Developer Documentation -> Office 97 (or 2000) Documentation ->
Office -> Office 97 (2000) VB Reference -> Volume 3 -> Microsoft Word
Reference
http://msdn.microsoft.com/library/default.asp?URL=/library/officedev/odecore/ODEstartpage.htm


Oh and uh ... good luck. :) Win32::OLE is a fantastic module but it suffers
the burden of relying on MS's wacky APIs for VBA. I often found myself
scratching my head and whispering 'What the hell?'

- jc

-------------------------------------------------
James Diggans              Phone:    301.987.1756
Gene Logic, Inc.           FAX:      301.987.1701
[EMAIL PROTECTED]     Cell:     301.908.2477
-------------------------------------------------



                                                                                       
                                          
                    Lee Goddard                                                        
                                          
                    <Home@LeeGodd        To:     [EMAIL PROTECTED]                
                                          
                    ard.com>             cc:     [EMAIL PROTECTED]   
                                          
                                         Subject:     Re: Win32::OLE in Word - 
$wordApp->{Visible} matters?                      
                    02/28/01                                                           
                                          
                    06:05 PM                                                           
                                          
                                                                                       
                                          
                                                                                       
                                          




Would you mind telling me where I can find ANY docs
on getting started with Win32::OLE and Word?

Thanks in anticipation,

Lee
At 16:31 28/02/01 -0500, [EMAIL PROTECTED] wrote:

>Hoping someone on this list has some experience w/ the bizarre behaviour
>I'm seeing in Word using Win32::OLE. I have a rather large script that
>produces an extensive report. As part of my debugging process I have the
>line:
>
>$opt_debug and $wordApp->{Visible} = 1;
>
>so that Word opened up, and I could watch it do its thing. When I had the
>script completely working, no errors, etc, and ran it w/o the debug flag
>all sorts of bizarre behaviour ensued. I localized it to this call:
>
>$wordDoc->Tables($currTable)->blah blah blah
>
>The call to Tables (used many times in the script) using a valid table
>number is _successful_ if Word is visible and FAILS if it's hidden,
>returning undef. For the life of me, I can't figure out why. Anyone have
>any insight? Might this be a bug in Win32::OLE? Or in VB? :P
>
>TIA,
>-jc





_______________________________________________
ActivePerl mailing list
[EMAIL PROTECTED]
http://listserv.ActiveState.com/mailman/listinfo/activeperl

Reply via email to