Apache OpenOffice Community Forum

Posted: **Tue Mar 25, 2008 3:07 am**

Running under Windows XP
Version OOo 2.3

I have this very simple code:

Sub HelloWorld
Print "Hello, world."
End Sub

Sub HelloAgain
	Dim s As String

rem cursor is positioned here

	s = HelloWorldString()
	MsgBox s
End Sub

Function HelloWorldString() As String
	HelloWorldString = "Hello, again, World"
End Function

When my cursor is positioned as in the above, and I click the green button to run basic, the first macro "HelloWorld" executes. I can run the "HelloAgain" macro... but only by switching to the spreadsheet and going through all the menu: Tools -> Macro etc.

I want to be able to execute a macro of my choosing from the IDE.

In Excel, using VBA, the macro to execute depends on where the cursor is in the listing.

This shouldn't be so hard!

Keith

Posted: **Tue Mar 25, 2008 4:33 am**

when executing from the IDE, the first code block (func or sub) will be executed. Generally, you will have a sub called main at the top. you then use this sub as a sort of driver to call the other subs/funcs.

Code: Select all

Sub main()
   HelloWorld REM CALL HelloWorld Sub
   HelloAgain REM now call HelloAgain
   REM AND SO FORTH
End Sub

Posted: **Tue Mar 25, 2008 1:16 pm**

Thanks, QuazzieEvil! That was what I was suspecting, but it never hurts to ask. Guess I got a little spoiled using the Excel IDE; however, I can deal with it. Thanks for the quick reply!!

Apache OpenOffice Community Forum

[Solved] IDE question: running a macro

[Solved] IDE question: running a macro

Re: IDE question: running a macro

Re: IDE question: running a macro