Set Extra Host Options with VBA 1

[jazznaura]

hi all,

Need help figuring out the correct syntax (Excel vba) for the below property, i cant find an example anywhere
My object browser is working (in excel) but crashes when i try to access the help files.

Property Lines As Integer
Member of EXTRA.ExtraHostOptions
Returns or sets the number of lines on a page


I have tried the follow to no avail.

System.ExtraHostOptions.Lines = 25
System.Lines = 25
ExtraHostOptions.Lines = 25
System.HostOptions.Lines = 25
Sess0.ExtraHostOptions.Lines
Sess0.Lines = 25


i'm sure its something obvious but my mind has gone blank
any help would be great.

thanks
jazznaura

 

[Lakare]

Have you tried to make a HostOptions Object first?

Doing something like this should create your HostOptions object, and then you should be able to use the Lines function.

Dim Hostoption as Object
Set Hostoption = Sess0.Screen.HostOptions

Lakare

 

[jazznaura]

thats great Lakare worked a treat, thanks very much.

jazznaura.