[Bug 120414] New: can't run VBA macros from command line

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=120414

          Priority: P3
            Bug ID: 120414
          Assignee: ooo-issues@incubator.apache.org
           Summary: can't run VBA macros from command line
          Severity: major
        Issue Type: DEFECT
    Classification: Application
                OS: All
          Reporter: Phillip.M.Feldman@gmail.com
          Hardware: All
            Status: UNCONFIRMED
           Version: AOO 3.4.0
         Component: programming
           Product: spreadsheet

Created attachment 78786
  --> https://issues.apache.org/ooo/attachment.cgi?id=78786&action=edit
this file contains the above macro code

I've created an .ods file containing the following VBA macro:

   REM  *****  BASIC  *****

   Sub Main
   MsgBox("Hello")
   End Sub

I'm unable to run this macro from the command line. I've tried it on three
different computers running three different operating systems (Windows XP,
Windows 7, and Redhat Linux version 5.4).  The actual command that I'm issuing
follows:

   soffice "test1.ods" "macro://test1/Standard.Module1.Main()"

If macro security is turned on, I get a message that the macro cannot run
because of my macro security level.  If I turn off macro security, issuing the
above command causes the Calc application to open but does not cause the macro
to run.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Bug 120414] can't run VBA macros from command line

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=120414

--- Comment #3 from pfeldman <Ph...@gmail.com> ---
There is a missing a quote; this should read as follows:

soffice test1.ods "macro://./Standard.Module1.Main()"

Thanks so much for responding!!

Phillip

P.S. It would be great if this were documented somewhere.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Bug 120414] can't run VBA macros from command line

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=120414

hanya <ha...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |hanya.runo@gmail.com

--- Comment #2 from hanya <ha...@gmail.com> ---
Macro stored in the document should be specified as follows: 
soffice test1.ods macro://./Standard.Module1.Main()"

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Bug 120414] can't run VBA macros from command line

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=120414

Edwin Sharp <el...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |CONFIRMED
                 CC|                            |elish@apache.org
             Latest|---                         |4.1-dev
    Confirmation on|                            |
         Issue Type|DEFECT                      |ENHANCEMENT
     Ever confirmed|0                           |1
           Severity|major                       |normal

--- Comment #4 from Edwin Sharp <el...@apache.org> ---
Per comment 3 - update help.

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.

[Bug 120414] can't run VBA macros from command line

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=120414

--- Comment #1 from pfeldman <Ph...@gmail.com> ---
It would be great to have some response as to whether anyone is able to
replicate this issue.

-- 
You are receiving this mail because:
You are the assignee for the bug.