Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options
 
PerlMonks  

convert some marco to perl

by benlaw (Scribe)
on Oct 20, 2008 at 10:58 UTC ( [id://718192]=perlquestion: print w/replies, xml ) Need Help??

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

Hi All monk,
Study from http://www.xav.com/perl/faq/Windows/ActivePerl-Winfaq12.html#convert_vba , wanna to convert below vba marco to perl code, but not success, especially the "Filename:=" & ":=False" pattern, pls help, thanks a lot!
ActiveWorkbook.SaveAs Filename:= _ "D:\Documents and Settings\kkman\Desktop\statfbbatmp2008WKY41. +mht", _ FileFormat:=xlWebArchive, CreateBackup:=False

Replies are listed 'Best First'.
Re: convert some marco to perl
by Corion (Patriarch) on Oct 20, 2008 at 11:31 UTC

    It helps to know a bit about Visual Basic when translating from Visual Basic to Perl. The := syntax is for named arguments. Read the Win32::OLE documentation about them:

    $ex->Dmethod($RequiredArg1, {NamedArg1 => $Value1, NamedArg2 => $Value +2});
Re: convert some marco to perl
by planetscape (Chancellor) on Oct 21, 2008 at 13:05 UTC

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: perlquestion [id://718192]
Approved by moritz
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others rifling through the Monastery: (5)
As of 2026-02-11 13:29 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?
    hippoepoptai's answer Re: how do I set a cookie and redirect was blessed by hippo!
    erzuuliAnonymous Monks are no longer allowed to use Super Search, due to an excessive use of this resource by robots.