hi Asa rossoff,
Thanks alot for your advise could please forward the tested macro with
these changes.
thanks in advance.
On Mon, Mar 12, 2012 at 7:37 AM, Asa Rossoff <a...@lovetour.info> wrote:
> 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
>
--
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
