H
Harddrive747
I am currently overseeing 10 location and in those 10 location we are
monitoring stats on 10 areas of focus. I need to create 10 powerpoint
presentation, one for each location and have the 10 area of focus which are
charts in excel pasted/linked into the each presentation.
I know that I can open the powerpoint presentation and the corresponding
spreadsheet and manually link each chart into the presentation. I don't like
that because that will be very time consuming. Not to mention to make them
look the same.
What I would like to do is to write a macro that would begin in PowerPoint
and have it switch to Excel, copy the chart and then return to PowerPoint and
paste a link to it on a new slide. Most of the writing of the script can be
done by me because I have done this other times. What I want to make sure of
is that when I write the code in PowerPoint that I will get the chart pasted
and linked.
I recorded the macro and this is what it put into the code in PowerPoint
Sub Copy_Test()
'
' Macro recorded 12/16/2009 by Terry Palmer
'
With ActiveWindow.Selection.ShapeRange
.Left = 27
.Top = 15.375
.Width = 666
.Height = 509.25
End With
End Sub
This way, I run the macro and in 5 minutes, instead of an hour, I'm done.
Any help with the macro code would be greatly appreachated.
monitoring stats on 10 areas of focus. I need to create 10 powerpoint
presentation, one for each location and have the 10 area of focus which are
charts in excel pasted/linked into the each presentation.
I know that I can open the powerpoint presentation and the corresponding
spreadsheet and manually link each chart into the presentation. I don't like
that because that will be very time consuming. Not to mention to make them
look the same.
What I would like to do is to write a macro that would begin in PowerPoint
and have it switch to Excel, copy the chart and then return to PowerPoint and
paste a link to it on a new slide. Most of the writing of the script can be
done by me because I have done this other times. What I want to make sure of
is that when I write the code in PowerPoint that I will get the chart pasted
and linked.
I recorded the macro and this is what it put into the code in PowerPoint
Sub Copy_Test()
'
' Macro recorded 12/16/2009 by Terry Palmer
'
With ActiveWindow.Selection.ShapeRange
.Left = 27
.Top = 15.375
.Width = 666
.Height = 509.25
End With
End Sub
This way, I run the macro and in 5 minutes, instead of an hour, I'm done.
Any help with the macro code would be greatly appreachated.