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.
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.
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.
I'll think you have made a copy/past from another macro because you dont have the fieldnames in the macro inside the qvw.
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.
set ContractNr = ActiveDocument.fields("Sales Order ID").GetSelectedValues
If ContractNr.Count=1 Then
ActiveDocument.GetSheetObject("CT01").ExportBitmapToFile "C:\TEST\test.png" 'change path here
Msgbox("Select one value.")