Copy to Clipboard option not working for container object

[Anonymous]

Hi all,

I am trying to copy the container object using Copy to Clipboard option but not able to copy the container,

Please help me out with this.

R/Murali.

[Anonymous]

Hi murli, I have tried copying it as both object and as an image. Both works fine. Can you please add some info to your problem.

[rahulpawarb]

Hello Murli,

Please check for Copy/Clone Sheet Objects option present under Security Tab of Sheet Properties (Alt + Ctrl + S). If it is deselected then select it and click OK. Post this you can able to copy the container object.

Please correct me if I misunderstood the scenario.

Regards!

Rahul

[Anonymous]

Hi Rahul,

copy/clone option is enabled, still iam not able to copy.

R/Murali.

[Anonymous]

Hi Shiva,

find the sample file below.

R/Murali

[stabben23]

Hi,

Your macroname is CopyCNR but you try to trigger macro copy, could that be Your problem?

[stabben23]

I'll think you have made a copy/past from another macro because you dont have the fieldnames in the macro inside the qvw.

[stabben23]

If you do like this you can save a png of the container to a path instead. Also change the trigger in the button to CopyCNR.

Sub CopyCNR
set ContractNr = ActiveDocument.fields("Sales Order ID").GetSelectedValues
If ContractNr.Count=1 Then
  ActiveDocument.GetSheetObject("CT01").ExportBitmapToFile "C:\TEST\test.png" 'change path here
  Else
Msgbox("Select one value.")
End If
End Sub

[Anonymous]

Thanks Staffan, now iam able to copy container object.

R/Murali.