Set Refrence by button click

[#1]

Hi All,

This question might be some how funny, but i am having some hopes there will be chance of doing it.

Without using the macro function, can we able to provide "Set Reference" to the bar chart by using BUTTON click ?

I hope my question reached to you all, please let me know if need more briefly .

Thanks in advance.

[Anonymous]

Venkat,

I think if you must have a button for this, you have to use a macro.

Regards,

Michael

[#3]

Hi Michael,

Thanks for your response on this post.

Will that macro works on all web browser ?

Thanks in advance.

[ThornOfCrowns]

Macros / VBA will not work in Webview.

[Anonymous]

Don't know, just give it a try.  It is a simple macro, no system access required, there are chances it works in IE plugin but not in AJAX.

[ThornOfCrowns]

Sorry, Michael, I keep forgetting about the IE plugin! There is a chance it will work, but it's not a given.

[Anonymous]

Yes James, I know...  Trying to avoid macros, even the simple ones.  I wish it was always possible

Worth trying anyway if it's really needed.

[ThornOfCrowns]

I think the future QV path is to eradicate VB completely and to 'guide' developers to use QV Triggers etc.

[#9]

Hi Michael,

I tried testing through web browser by using the below macros, what i seen there is only by using IEPlugin the "Set Reference" is working fine, for "Full Browser" it is not working.

Sub SetRef

ActiveDocument.GetApplication

set Obj1= ActiveDocument.GetSheetObject("CH01")

Obj1.SetReference

End Sub

Sub ClearRef

ActiveDocument.GetApplication

set Obj1= ActiveDocument.GetSheetObject("CH01")

Obj1.ClearReference

End Sub

Can you please help me out, is there is a chance of getting this feature of "Set Reference" without using the "Set Refrence" property. i.e; like by using the "Alternate State" or some other approach .

Thanks in advance

[#10]

HI Venkat,

Right Click on BarChart, Select Set Reference .

Then you can select any analysis on chart, what ever the Selection is done it was Highlighted, others will remains same.

Remember 2 Things: 1) Even If you reload the application SET Reference will Disappear

                                    2) Even If you Close the application SET Reference will Disappear

Regards,

Helen