Paste excel graphs to powerpoint with borders

Microsoft Office 2007 enterprise
April 28, 2010 at 22:42:49
Specs: Windows Vista
Hi! I am trying to add some codes to a Macro
similar to the one in this previous post
(http://www.computing.net/answers/office/past
e-excel-graphs-to-powerpoint/7040.html) that
will allow me to not only paste Excel graphs to
Powerpoint, but to also make them have black
borders or outlines once they are pasted.
Would any of you know how I can go about
this? Thanks.

See More: Paste excel graphs to powerpoint with borders

Report •

#1
April 29, 2010 at 05:43:22
Hi,

If you are using the code from the post you mentioned, there is code to position and size the chart on the slide. You can add the line information at the same place in the macro.

Add this code to create a border around each chart, after this line:

        .Height = 289.625
        
        .Line.Style = msoLineSingle
        .Line.Weight = 4
        .Line.ForeColor.RGB = RGB(0, 0, 0)
        .Line.Visible = msoTrue

Regards


Report •

#2
April 29, 2010 at 05:51:03
Just tried the code and it works perfectly. Thank you so much,
Humar! I'm still learning how to use Macros...wish I studied them
earlier. I'll try making a Macro to export to Word soon. = )

Report •

#3
April 29, 2010 at 07:03:08
Glad to hear that the code worked, and thanks for the feedback.

Regards

Humar


Report •

Related Solutions

#4
April 30, 2010 at 18:03:03
Yes, I came across that tool as well. Very useful too, though
learning the Visual Basic and Macros seems to be more flexible.
Thank you very much also for the help!

Report •

Ask Question