Button

[#1]

hi,

How to work on with buttons of "copy current page to clipboard", "send data to tab delimited file". Please give me the solution with some example.

Thnks

[maneshkhottcpl]

Hi,

U want to copy the objects of sheet or the entire sheet as objects?

[deepakk]

hi venkat,

I was wondering, do you want to export the data to excel or a text format. I would suggest you do it in a single click of a button.

I hope the attach application helps you out.

[#4]

hi thnks for reply,

please can you provide in both ways.

Thnks

[#5]

hi Deepak thnks for ur reply,

I am not full licensed version of the QlikView file, so please can you provide screenshots of that attachements.

Thnks

[maneshkhottcpl]

hi,

Use this expression to copy the object in clip board

and then paste anywhere usin ctrl+v

ActiveDocument.GetSheetObject(

"CH1632").CopyBitmapToClipboard

Need more ?

[#7]

can you explain clearly and with example. I am new QlikView development.

Thnks

[deepakk]

hi Venkat.

Below is the code which we write in Macro Editor (Ctr +M)

sub test

set Graph = ActiveDocument.GetSheetObject("CH01")

Graph.Export "C:\test.xls",CHR(9)

end sub

where "CH01" is the Chart objectID. you will find the General tab of Chart properties.

CHR(9) is code for tab .

You can also change the .xls file .txt.

Now Create a Button and add an action to it.

Properties-->Action--> External-->Run Macro and now the macro name i,e test.

I hope this helps.

[#9]

hi Manesh,

I want to copy the entire sheet as objects.

Can you provide with example and screenshot

Thnks

[maneshkhottcpl]

Hi,

To copy the entire sheet u can use

ActiveDocument.Activesheet.CopyBitmapToClipboard

after running this macro u can use ctrl+v anywhere to paste the sheet as image.

U can also create a power point presentation of the sheet , please refer the Attached document.

Please let me inform i m correct or not.