Sunday, 15 September 2013

Using Word Built in styles with Excel VBA

Using Word Built in styles with Excel VBA

I'm trying to write to a word document from Excel using VBA. However when
i try to apply the style heading 1 to the text it has to be English
version of Office. How can i refer to the built in styles of office?
This is what i got now:
wrdApp.Selection.Style = "Heading 1"
wrdApp.Selection.TypeText Text:= "Test heading
I want something similar to this (to make it international), however this
does not work:
wrdApp.Selection.Style = WdBuiltinStyle.wdStyleHeading1
wrdApp.Selection.TypeText Text:= "Test heading
Any tip or answer or constructive comment is appreciated. :)

No comments:

Post a Comment