Private Sub Command1_Click() Dim mExe As Excel.Application Dim mWd As Word.Application Set mExe = GetObject(, "excel.application") Set mWd = GetObject(, "word.application") Dim Cht As Chart Set Cht = mExe.ActiveSheet.ChartObjects(1).Chart Cht.ChartArea.Copy mWd.ActiveDocument.Activate mWd.PasteAndFormat (wdChartPicture) Set Cht = Nothing Set mWd = Nothing Set mExe = Nothing End Sub
Office 2003 开始安装中就带有 Microsoft Office Document Image Writer(忘了是不是默认选项了)虚拟打印机。 把它设为默认打印机输出就可以了。
Dim mExe As Excel.Application
Dim mWd As Word.Application
Set mExe = GetObject(, "excel.application")
Set mWd = GetObject(, "word.application")
Dim Cht As Chart
Set Cht = mExe.ActiveSheet.ChartObjects(1).Chart
Cht.ChartArea.Copy
mWd.ActiveDocument.Activate
mWd.PasteAndFormat (wdChartPicture)
Set Cht = Nothing
Set mWd = Nothing
Set mExe = Nothing
End Sub
把它设为默认打印机输出就可以了。