topic MS Word VBO in Product Forum

MS Word VBO

TomMason — Tue, 25 May 2021 11:40:13 GMT

Hi All,

Hope you're well?

Quick question as I can't remember it offhand....

I am using the MS Word VBO to format a Word document (basically just opening it and then a quick format), however we've recently upgraded to v6.10 and I need the word document to set a Font size but also set up a page orientation as Landscape, as the file I am opening is Portrait.

How do I manage this? Can't seem to find the answer?

Kindest Regards,

Tom

Re: MS Word VBO

HarpreetKaur — Wed, 26 May 2021 05:37:48 GMT

Hello Tom,

A very quick way would be to simply add the below code stage in your Word VBO:
Dim doc as Object = GetDocument(handle,documentname)
doc.PageSetup.Orientation=1

1 is the value for Landscape, 0 for Portrait.

Regards
Harpreet

Re: MS Word VBO

MiguelCarrillo — Wed, 26 May 2021 06:03:57 GMT

Hello Tom

I attached you a process and an extend version of the MS Word VBO object, that includes 2 new actions:

Set Document Orientation
Set Font Size

Hope that help you with the process your making.
If you have any doubts. Feel free to contact me