Finding variable corresponding to user selected cell/column

[SaraCH]

Hi,

I am trying to find the document variable corresponding to a cell/column/section selected by user during formatting using BO SDK. How to get this information?. This is an urgent requirement. Any quick help/idea/sample code would be very useful.

Thanks,
SaraCH

 

[krishbanerjee]

bobj---> BO object

Public bobj As New busobj.Application


Set Bodoc = bobj.Documents.Open(/* provide the required parameters */)

then

Bodoc.DocumentVariables.(count/name/etc etc)

...u get all the information about the document variables.

hope it helps

krish

 

[krishbanerjee]

i think u will have to look for some active section kind of stuff....i have searched the BO api but couldn't find any thing like that...probably u will have to write a Macro using the Visual basic Editor Tools-->Macro....

 

[SaraCH]

Hi,

Yes.. the issue is in finding only the selected variable. Interestingly i can the see selected variable's formula in the formula editor toolbar. However i do not know how to get to that particular text box/area since BO SDK seems to support only Button and Popup Menu CmdBar Controls.

Also when i right click on the selection and select "Variables..", the dialog box shows list of variables highlighting the selected one.

This tells me that getting the selected variable is possible though i do not know at the moment how.
Any input is welcome.

SaraCH