Re: $$Excel-Macros$$ How to copy text frame from excel and paste in bottom of ppt slide

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 wrote: > Hi Rekha, > > You can change the line that sets the vertical position from: > > newPowerPoint.ActiveWindow.Se

RE: $$Excel-Macros$$ How to copy text frame from excel and paste in bottom of ppt slide

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.Selectio