98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Creating a macro to replace an object in Powerpoints
Creating a macro to replace an object in Powerpoints
Resolved · High Priority · Version 2010
Catherine has attended:
Excel Intermediate course
Excel Advanced course
Excel VBA Intro Intermediate course
Creating a macro to replace an object in Powerpoints
How can I change an object in multiple powerpoints in multiple folders
RE: creating a macro to replace an object in Powerpoints
Hi Catherine,
Thank you for the forum question.
What you want is very complicated and it takes a lot of code doing it. We are controlling other Microsoft applications from Excel on our Excel VBA Advanced course.
I suggest that you have a look at the website www.rondebruin.net . They are specialist in this field and you will find a lot of examples.
I do not know how many PowerPoint presentations you are talking about and how often you need to do it but if it is not many and it is not something you need to do often, then I do not think it is a good idea all the hard work with a macro.
If it is the same object you want to change in all the presentations you can link them between the presentations. Then you only need to change the source object and the rest of the presentations will update automatically.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
RE: creating a macro to replace an object in Powerpoints
Hi Jens, thanks for the reply! Yes it is a lot of powerpoints - about 450 powerpoints and I just want to update the company logo on them as we had a brand change. the powerpoints are split between about 40 folders... So I want the macro to sequentially run through each folder.
If I were to do it manually, say allow 90 seconds to open up each powerpoint, delete the current logo and replace it with a new logo - we're looking at about 11 hours of solid work! So I figured writing a macro would be better and help me put into practice what I learned. I'll check the website you recommend and see how far I get.
I do have another - simpler question though. I have a list of 400 names and some of them have a Yes next to them. So I am working with 2 columns of data, I want the macro to only display the names which have a yes next to them. I tried this:
Sub ForEachTest()
For Each i In Range("A1:A347")
If i(0, 1) = "" Then
Kill cell
End If
Next i
End Sub
But I think I'm getting confused with whether I need decision code of For Each or maybe I need a variables. Are you able to help with this one?
Many thanks, Catherine
Wed 27 Aug 2014: Automatically marked as resolved.
Training information:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Checking if a calculation adheres to Order of PrecedenceWhen writing formulas you must make sure that results will be calculated as you intended. |