Hi Rekha,
You can change the line that sets the vertical position from:
newPowerPoint.ActiveWindow.Selection.ShapeRange.Top = 80
to this (one line):
newPowerPoint.ActiveWindow.Selection.ShapeRange.Top =
newPowerPoint.ActivePresentation.PageSetup.SlideHeight -
newPowerPoint.ActiveWindow.Selection.ShapeRange.Height - 80
which places the chart 80 picas (1/72") from the bottom of the slide instead
of from the top. You could use similar code with the ShapeRange.Left
property to place the chart in relation to the right side of the slide
instead of the left if desired.
The macro could be simplified with additional variables and/or With blocks
to avoid all the redundant object references you see in the above line, but
the code provided should do the trick.
Oh, when I tested your code on my system I had to change one line. The
following did not find the Powerpoint window:
AppActivate ("Microsoft PowerPoint")
But this revision worked fine:
AppActivate newPowerPoint.Caption
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of rekha siri
Sent: Sunday, March 11, 2012 12:20 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ How to copy text frame from excel and paste in
bottom of ppt slide
Greetings to one and all,
please provide a vba code for copying text frame from excel and to paste in
bottom of power point slide.
i have macro code in attached note pad in which macro pastes the text frame
on right hand side of slide
but can any one provide code to paste text frame in bottom of slide.
Thanks,
Rekha
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
----------------------------------------------------------------------------
--------------------------
To post to this group, send email to excel-macros@googlegroups.com
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
