VBA在活动的Word文档光标处粘贴选中的Excel Chart图表

用户注册

投稿取消

文章分类:

还能输入300字

上传中....

热门文章更多>>

标签更多>>

照片无损放大免费软件怎么挣钱谷歌软件工程师工资淘宝上的邮费链接怎么刷淘金币的 codesys编程手册教材 ub开头的视频软件姓名后面加横线怎么弄 word中如何画虚线 word矩形选择快捷键 word没有访问权限mac 怎么看硬盘碟片数量不属于演示文稿的放映方式是 ipa修改软件版本号网易邮箱163注册 :recover为啥恢复不了

专题更多>>

最新文章更多>>

乱气质

VBA在活动的Word文档光标处粘贴选中的Excel Chart图表

Sub ChartToDocument()
' Set a VBE reference to Microsoft Word Object Library

Dim WDApp As Word.Application
Dim WDDoc As Word.Document

' Make sure a chart is selected
If ActiveChart Is Nothing Then
    MsgBox "Please select a chart and try again.", vbExclamation, _
        "No Chart Selected"
Else
    ' Reference existing instance of Word
    Set WDApp = GetObject(, "Word.Application")
    ' Reference active document
    Set WDDoc = WDApp.ActiveDocument
    
    ' Copy chart as a picture
    ActiveChart.CopyPicture Appearance:=xlScreen, Size:=xlScreen, _
        Format:=xlPicture

    ' Paste chart at cursor position
    WDApp.Selection.PasteSpecial Link:=False, DataType:=wdPasteMetafilePicture, _
        Placement:=wdInLine, DisplayAsIcon:=False

    ' Clean up
    Set WDDoc = Nothing
    Set WDApp = Nothing
End If

End Sub