Apache OpenOffice Community Forum

In my Calc-file I have the basic macro:
Sub sMySub
msgbox "hello"
End Sub

I tried following lines in the XP - command window while in the map "C:\Program Files\OpenOffice.org 3\program>"

soffice.exe "macro:///Standard.Module1.sMySub"
soffice.exe "macro:///[My File.ods].Standard.Module1.sMySub"
soffice.exe "C:\My Documents\My File.ODS" "macro:///Standard.Module1.sMySub"
soffice.exe "C:\My Documents\My File.ODS" "macro:///[My File.ods].Standard.Module1.sMySub"
soffice.exe "C:\My Documents\My File.ODS" "macro:///My File.ods.Standard.Module1.sMySub"

Nothing works except switching the active window to my already running "My File.ods" with the last 3 examples above...

What am I doing wrong?

Hi, And avoid using spaces and national characters in the file name.
______
Bernard

Thank you B Marcelly, I've spend hours looking for this and it's so obvious

It even works with spaces in the name

Hi,

Is it then possible to run a OO macro within a file "test123.ods", without opening the file? or even without getting a message for "ENABLE MACROS"?

I could run a macro through command line, but i dont want calc file to open.

Any way o do it?

Abhi

No document file is specified and opened. However, the macro must reside in "My macros" container.