[Solved] Macro opens Calc file, but not macros

Creating a macro - Writing a Script - Using the API (OpenOffice Basic, Python, BeanShell, JavaScript)
Locked
User avatar
alf50
Posts: 131
Joined: Sun Jun 13, 2010 2:55 pm

[Solved] Macro opens Calc file, but not macros

Post by alf50 »

This Macro will open my Calc Application but will not activate the macros. How do I fix that?

Code: Select all

Sub OpnCKIN

rem ----------------------------------------------------------------------
dim NewWorkBook as object
dim cmd as string
cmd = "file:///C:/Users/alfor/Desktop/KwV8/1ChecK_IN.ods"
dim args1(0) as new com.sun.star.beans.PropertyValue
args1(0).Name = "ReadWrite"
args1(0).value = false
NewWorkBook= StarDesktop.loadComponentFromURL(cmd,"_blank",0,args1())
rem ----------------------------------------------------------------------

end sub
/code]
Last edited by MrProgrammer on Mon May 12, 2025 4:35 pm, edited 1 time in total.
Reason: Tagged ✓ [Solved]
OpenOffice 4.1.14 on Mac Catalina(10.15.7), RasPi4B (TwisterOS-8/2023update) & MS Wnds10
Bidouille
Volunteer
Posts: 641
Joined: Mon Nov 19, 2007 10:58 am
Location: France

Re: Macro will open my Calc Doc but will not activate Macros?

Post by Bidouille »

Code: Select all

args1(0).Name = "MacroExecutionMode"
args1(0).Value = com.sun.star.document.MacroExecMode.ALWAYS_EXECUTE_NO_WARN
Locked