convert some marco to perl

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
[download]

Comment on convert some marco to perl Download Code

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});` [download]	[reply] [d/l] [select]
Re: convert some marco to perl by planetscape (Chancellor) on Oct 21, 2008 at 13:05 UTC
marto's writeups (in particular, Re: VBA to Perl) have excellent advice on converting VBA macros to Perl. HTH, planetscape	[reply]