 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / General PowerPoint Questions / July 2008Need an advice!
Hi everubody, In a VBA project I need to add clinets logo to my presentations using VBA some of them might be over 100 slides . I'm thinking to have a placeholder for logo on the first page that I can paste the logo and then run a macro to copy the logo on every other slide. Any thoughts that what kind of placeholder I should use or how should I approach this? I greatly appreciate any suggestions ...  SignatureBest regards, Edward I have to add that because some slides dont need logos I can't use master/footer , unles there is a way to use VBA and remove those logos from some slides and leave the rest intact... SignatureBest regards, Edward > Hi everubody, > In a VBA project I need to add clinets logo to my presentations using VBA [quoted text clipped - 3 lines] > placeholder I should use or how should I approach this? I greatly appreciate > any suggestions ... Hi Edward, Some things that are fairly obvious to human eyes are difficult to explain in VBA. The bottom line comes down to - how does the code know which slides get the logo (and if it is in variable locations) and where to put them (both in x,y co-ordinates and layer). If this can be answered using basic logic, than the rest of the mechanics are pretty straight forward. SignatureBill Dilworth A proud member of the Microsoft PPT MVP Team Users helping fellow users. http://billdilworth.mvps.org -_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_ vestprog2@ Please read the PowerPoint FAQ pages. yahoo. They answer most of our questions. com www.pptfaq.com . >I have to add that because some slides dont need logos I can't use > master/footer , unles there is a way to use VBA and remove those logos [quoted text clipped - 11 lines] >> appreciate >> any suggestions ... > I have to add that because some slides dont need logos I can't use > master/footer , unles there is a way to use VBA and remove those logos from > some slides and leave the rest intact... The simplest thing might be to use multiple masters, some with the logo, some without. It'd be fairly simple to write a macro that copies the logo (or any selected graphic) from one slide to the rest of the slides. To keep it from copying to ALL slides, you'd need a way of determining which slides get the logo and which don't. ' This'll copy the selected shape(s) to all other slides: Sub CopyToAllSlides() Dim oSh As ShapeRange Dim oSl As Slide ' be sure to select something first or it will error Set oSh = ActiveWindow.Selection.ShapeRange ' copy the shape oSh.Copy For Each oSl In ActivePresentation.Slides ' don't copy to the slide the shape came from originally If oSl.SlideIndex <> oSh.Parent.SlideIndex Then oSl.Shapes.Paste End If Next End Sub ----------------------------------------- Steve Rindsberg, PPT MVP PPT FAQ: www.pptfaq.com PPTools: www.pptools.com ================================================ Live and in personable in the Help Center at PowerPoint Live Sept 21-24, San Diego CA, USA www.pptlive.com Thanks Steve and Bill . I was thinking if it's possibile to have a hidden textbox ( or a textbox with hidden symbol ) and when I want to copy the logo I check each slide to see if that hidden symbol exist skip that particuar slide and go to the next? Also I wonder is it possible to access a logo if its part of master using VBA? ( because when the logo or any other object is part of master we can't select it or delete it but I don't know if VBA can help us to delete them.) The Idea of having two different masters seems to work too , Thanks again both of you for your time :) SignatureBest regards, Edward > > I have to add that because some slides dont need logos I can't use > > master/footer , unles there is a way to use VBA and remove those logos from [quoted text clipped - 39 lines] > Sept 21-24, San Diego CA, USA > www.pptlive.com > Thanks Steve and Bill . I was thinking if it's possibile to have a hidden > textbox ( or a textbox with hidden symbol ) and when I want to copy the logo > I check each slide to see if that hidden symbol exist skip that particuar > slide and go to the next? That would be simple enough. If you have a shape named "Bubba" or whatever sitting off the slide, you could do: Dim oBubbaShape as Shape On Error Resume Next Set oBubbaShape = oSld.Shapes("Bubba") If Not oBubbaShape Is Nothng Then ' use the code to paste the logo in as quoted earlier End If > Also I wonder is it possible to access a logo if > its part of master using VBA? Sure, but how you do it may depend on the version of PPT you use. > ( because when the logo or any other object is > part of master we can't select it or delete it Sure ya can. Manually, View, Master, SlideMaster first. Then select the shape and go to town on it. but I don't know if VBA can > help us to delete them.) The Idea of having two different masters seems to > work too , Thanks again both of you for your time :) ----------------------------------------- Steve Rindsberg, PPT MVP PPT FAQ: www.pptfaq.com PPTools: www.pptools.com ================================================ Live and in personable in the Help Center at PowerPoint Live Sept 21-24, San Diego CA, USA www.pptlive.com |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.