NamedRange.CopyPicture Method
Copies the NamedRange control to the Clipboard as a picture.
Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)
Syntax
'Declaration
Function CopyPicture ( _
Appearance As XlPictureAppearance, _
Format As XlCopyPictureFormat _
) As Object
Object CopyPicture(
XlPictureAppearance Appearance,
XlCopyPictureFormat Format
)
Parameters
Appearance
Type: Microsoft.Office.Interop.Excel.XlPictureAppearanceSpecifies how the picture should be copied.
Can be one of the following XlPictureAppearance constants:
Format
Type: Microsoft.Office.Interop.Excel.XlCopyPictureFormatThe format of the picture.
Can be one of the following XlCopyPictureFormat constants:
Return Value
Type: System.Object
Remarks
Optional Parameters
For information on optional parameters, see Optional Parameters in Office Solutions.
Examples
The following code example creates a NamedRange and populates it with the word Smith. It then uses the CopyPicture method to copy the NamedRange to the Clipboard as a bitmap.
This example is for a document-level customization.
Private copyBitmapRange As Microsoft.Office.Tools.Excel.NamedRange
Private Sub CopyAsBitmap()
copyBitmapRange = Me.Controls.AddNamedRange( _
Me.Range("C3"), "copyBitmapRange")
Me.copyBitmapRange.Value2 = "Smith"
Me.copyBitmapRange.CopyPicture( _
Excel.XlPictureAppearance.xlScreen, _
Excel.XlCopyPictureFormat.xlBitmap)
End Sub
Microsoft.Office.Tools.Excel.NamedRange copyBitmapRange;
private void CopyAsBitmap()
{
copyBitmapRange = this.Controls.AddNamedRange(
this.Range["C3"], "copyBitmapRange");
this.copyBitmapRange.Value2 = "Smith";
this.copyBitmapRange.CopyPicture(
Excel.XlPictureAppearance.xlScreen,
Excel.XlCopyPictureFormat.xlBitmap);
}
.NET Framework Security
- Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.