Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11
Default Charts to Word

Ian,

I've never moved charts to Word but this code works for
PowerPoint and I would assume a small modification would
do.

Mike

Sub ToPowerPoint()
' copies and paste all charts in the active workbook to
PowerPoint
'=================================
chtcnt = Charts.Count

Dim pp As Object
On Error Resume Next
Set pp = GetObject(, "PowerPoint.Application")
If Err.Number < 0 Then
Err.Clear
Set pp = CreateObject("PowerPoint.Application")
End If
pp.Visible = True
pp.Presentations.Add

For i = 1 To chtcnt
Charts(i).Activate
ActiveChart.ChartArea.Select
ActiveChart.ChartArea.Copy

With pp.ActivePresentation
.Slides.Add i, ppLayoutBlank
.Slides(i).Shapes.Paste
With .Slides(i).Shapes(1)
.Top = 75
.Left = 5
.Height = 350
End With
End With
Next i
End Sub

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Linked excel charts to Word doc jstidsto Excel Discussion (Misc queries) 0 February 3rd 10 04:19 PM
export Pivot Charts to MS Word? srpd Excel Discussion (Misc queries) 2 January 28th 10 10:56 PM
Excel Charts in Word Marc Charts and Charting in Excel 2 October 17th 07 11:40 PM
Multiple pie charts and merging them into word. Tina Charts and Charting in Excel 0 September 26th 07 02:34 PM
copying charts into MS Word kippers Charts and Charting in Excel 1 March 16th 07 02:20 PM


All times are GMT +1. The time now is 06:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"