[Solved] VBA macro to toolbar button

[gust]

Hey!

I draw the short straw at work and got tasked with converting all our MS Word templates to OO.

All macros seems to work when the template is opened in OO but in MS Word we have a toolbar with the macros assigned to buttons in the toolbar.

My question is: Is there a way to add macros written in VBA to a toolbar in OO?

thanks!

[floris v]

You can do that with Tools - Customize.

If your problem has been solved, please edit the first post in this thread and add [Solved] to the title bar.

[gust]

Sorry its really not that simple, When OO imports the VBA macros it creates a Sub around all VBA subs and then comments them out so you cant choose one of the VBA subs.

[esperantisto]

VBA is not supported in OOo (in standard builds, at least), is it? Thus, there’s no reason of adding buttons to the toolbar anyway.

[gust]

VBA is not supported in OOo (in standard builds, at least), is it? Thus, there’s no reason of adding buttons to the toolbar anyway.

Ok, that sucks, then i have to convert them manually

[floris v]

You said that the macros seemed to work? I was a bit surprised about that. Maybe you should try go-oo, that has better support for Excel VBA macros.

[gust]

You said that the macros seemed to work? I was a bit surprised about that. Maybe you should try go-oo, that has better support for Excel VBA macros.

yeah i thought so but upon some more research it seems like the styles already are in the template and not added by the macros in the template

[floris v]

I see, then you have some hard work ahead.

[gust]

I see, then you have some hard work ahead.

don't know about hard but certainly boring

[esperantisto]

The matter is, there’s no automatic or semi-automatic conversion of VBA into SB, you have to re-write the code. Well, good luck!

[RoryOF]

I found a site that purports to do some automatic conversion of VBA to OpenOffice BASIC. How good or bad it is I cannot say but you could try it out:
http://www.business-spreadsheets.com/vba2oo.asp