My idea goes as follows, but I'm not sure if it can be done of if it's a recommended solution. The pptx holds the code, and the excel workbooks hold no code. There might be smarter way to do this but I describe how I think it might work and that is defining different variables for each slide and then for each slide call a function to use the variables in. The idea is to get images pasted from Excel workbooks that easily can be updated if things changes (but still pasted as images and not linked). Hence the code needs to be able to find and update the correct image in the presentation.
1. PPTX with one import/update button opens file browser (preferably directly from same folder as pptx is in) to choose an workbook to update images from
2. Each slide is defined with different variables that is used in a function that is reused (to save space in the code so each new slide is defined by different variables on how that slide will be constructed/updated) - optional solution
3. Each slide's variables could look like this (note I don't know proper VBA coding but I hope you get the idea):
Slide number = SlideID(45)
Image type = Diagram / Range / (optional: the code defines cells that the script copy pastes just as if you do it yourself as an alternative not to use ranges in the workbook)
Image location = I suppose you need to define worksheet and things?
Image name = ImageName(chosen worksheet_given image name)
Image placement = top(50);left(50)
Image alignment = Sometimes I want two images next to each other with variable height. In those cases I want them to align the bottom to a specific height, I guess something like top(200) - if nothing then code will ignore this and only go with image placement
Image size = I believe image size sometimes can vary when pasting. When pasting images I want the option to limit the width of the image (the height can vary but keep proportions given the defined width).
Maybe more variables need to be defined?
Call function to throw these variables into
Same variables as the example above and then call the function for the next slide in the script. This could actually be the same slideID but the second image in the same slide is defined here with it's own variables.
4. When defining about 50-100 slides like that the script will go through each slide and use the function for each slide. The function should preferably do these steps:
a) Check if the slide number still exist, if not, go to the next slide in the script (it should be possible to delete slides that you don't want to use in this presentation)
b) If the slide number exist, check if the image name defined exist, if not, go to the next slide in the script
c)If the slide and image is found in the presentation, check if it exists in the chosen workbook (it might not because the images will come from two or more workbooks so in at least 50 % of the cases the image will not be in the chose workbook (there might be smarter ways to do this so the script doesn't get too slow).
d) If you find the slide, image in preesntation and image in workbook: delete image in presentation and paste the new image according to the given variables, then move on to the next slide in the script
5. The idea is that I construct the script and define the slides. Several slides already contain a lot of information and just need the images. Then I send this pptx and workbooks to colleagues who paste information in wb generating results for pptx to grab. If on short notice they need to update all the information they can update them easily and get a presentation with pasted images but everything they've done in the presentation remains:
a) deleted or added slides doesn't affect the update
b) changed orders of slides doesn't affect the update
c) changed content of slides does not affect - I understand however that a duplicated slide gets a new slideID and no longer is found by the script
19 фрилансеров(-а) в среднем готовы выполнить эту работу за $365
I have understand the project requirement & interested to work for this project. I will start right now and I will do it before your time . Please send a message so we can discuss more & start the project. Thanks
Hi I hope all is well with you. Yes, it's possible to use Excel object model and power point object model coding via vba. I can detail on private chat. Best Regards, Zurab
, ABLE TO WITHSTAND STRESS SITUATIONS ALSO DUE TO CONTACT WITH THE PUBLIC, PUNCTUAL IN THE EXECUTION OF THE TASKS ENTRUSTED. LOOKING FOR EXPERIENCES THAT ALLOW ME PERSONAL AND PROFESSIONAL GROWTH.