Import and update PPTX from several Excel workbooks - is this possible?

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):


'First slide'


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


'Second slide'


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

Квалификация: Excel, Visual Basic, Обработка данных, Visual Basic для приложений, Microsoft Office

Показать больше link powerpoint to excel cell, embed excel file in powerpoint 2016, link excel chart to powerpoint, link excel data to powerpoint chart, copy paste from excel to powerpoint not working, how to insert an excel file into powerpoint as an icon, link excel to powerpoint automatic update, how to link powerpoint to excel for dynamic data updates, import datetime mysql excel, update records excel, excel workbooks sheets update, access update table excel file, update vba excel 2003, macro script update database excel, code update sheet excel, update prices excel, import custom fields excel quickbooks, update data excel mysql, import mpp data excel using macro, import data project excel

О работодателе:
( 0 отзыв(-а, -ов) ) Bromma, Sweden

ID проекта: #24553314

19 фрилансеров(-а) в среднем готовы выполнить эту работу за $365


Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 265 projects successfully completed here. I have some comments and some ideas. I would like to have Больше

$600 USD за 7 дней(-я)
(249 отзывов(-а))

Hi, Would you like to see a quick demo of your Import and update PPTX from several Excel workbooks project before you award the project? You can consider it professionally done in a few hours. I have vast experience w Больше

$500 USD за 7 дней(-я)
(56 отзывов(-а))

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

$250 USD за 2 дней(-я)
(184 отзывов(-а))

Hi, Keen to work on this project. It would help to do some more discussions on this possible with a sample PPTX and Excel. Let me introduce myself as an expert VBA programmer. I have used VBA extensively for Excel, M Больше

$250 USD за 4 дней(-я)
(98 отзывов(-а))

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

$750 USD за 7 дней(-я)
(33 отзывов(-а))

Hi, Yes, it is possible. I have done a similar job before. My name is Virendra. I am experienced Data Analyst and Macro Developer. I have excellent knowledge and experience of Manipulating and Exchanging Data in Mu Больше

$500 USD за 7 дней(-я)
(94 отзывов(-а))

Hi, I'm interested in your project. these tasks could be done, but I suggest another way to perform all this task in an efficient way. I did lots of projects about manipulating PPTX files and excel files using VBA-Macr Больше

$300 USD за 3 дней(-я)
(51 отзывов(-а))

Hello, I've read your project requirements thoroughly. Yes it is possible and it's quite an easy task. I can achieve this through a VBA script. It will be quick and accurate. If interested, we can discuss this further Больше

$250 USD за 1 день
(12 отзывов(-а))

Hello. I know about Excel and macros programming. I could do a research to know what is possible to do. Relevant Skills and Experience .......

$250 USD за 7 дней(-я)
(3 отзывов(-а))

Hello, Reading your proposal carefully makes me to work for you. Now i understand what you want. I am familiar with Vb and Excel & macro. As a much experienced developer i can work for your job. Let me discuss more det Больше

$300 USD за 3 дней(-я)
(1 отзыв)

Greetings, Throughout my 35+ years career, I have used Excel extensively to manage the programs / projects / actions and the reporting requirements. Normalized/cleaned up lot of data, collected from various sources an Больше

$250 USD за 2 дней(-я)
(2 отзывов(-а))

Hello, I am Aziz Ayoubi, MS Excel and Access expert with more than 7 years experience, and 3 years with Google Sheets, VBA, Google Script and C# programmer and IT troubleshooting master. I read your requirements caref Больше

$250 USD за 2 дней(-я)
(3 отзывов(-а))

Hello Project Owner, Good Day to You. After read your requirement fully, Yes, it is indeed very much possible; linking PPTX with one or more Excel workbook. I do this every week Saturday & Sunday for our Monday clien Больше

$300 USD за 4 дней(-я)
(1 отзыв)
$555 USD за 10 дней(-я)
(0 отзывов(-а))

Dear, I am a certified professional microsoft developer (MCP) and I have extensive experience developing in VBA, I have made all kinds of macros, I can make the program you need, if you like write to me and we see the Больше

$250 USD за 2 дней(-я)
(0 отзывов(-а))

I am expert on typing, i am expert on excel, i am expert on projects and i am ready for any project right now. I will focus on your project and complete as soon as possible. I did many of automation works between pptx Больше

$250 USD за 7 дней(-я)
(0 отзывов(-а))


$556 USD за 10 дней(-я)
(0 отзывов(-а))

I am expert in PPT making.

$333 USD за 10 дней(-я)
(0 отзывов(-а))

Hello, Greetings... I read your projects details, and I'm perfect for the job as i have already done many projects in my organisation too within the time of data entry and presentations. Waiting for your response ov Больше

$250 USD за 3 дней(-я)
(0 отзывов(-а))