Ditutup

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

Keahlian: Excel, Visual Basic, Pemrosesan Data, Visual Basic untuk Aplikasi, Microsoft Office

Lihat lebih lanjut: 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

Tentang Pemberi kerja:
( 0 ulasan ) Bromma, Sweden

ID Proyek: #24553314

19 freelancer menawar dengan rata-rata $365 untuk pekerjaan ini

elqueabandona

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 Lebih banyak

$600 USD dalam 7 hari
(249 Ulasan)
7.0
dvcontact

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 Lebih banyak

$500 USD dalam 7 hari
(56 Ulasan)
6.5
mtdevil369

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 dalam 2 hari
(184 Ulasan)
6.3
finecodervw

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 Lebih banyak

$250 USD dalam 4 hari
(98 Ulasan)
6.0
zu02

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 dalam 7 hari
(33 Ulasan)
5.7
vsprybhanu

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 Lebih banyak

$500 USD dalam 7 hari
(94 Ulasan)
5.7
shahinrahimi

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 Lebih banyak

$300 USD dalam 3 hari
(51 Ulasan)
5.2
MonisZafar

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 Lebih banyak

$250 USD dalam 1 hari
(12 Ulasan)
4.1
VbaStudio

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 dalam 7 hari
(3 Ulasan)
3.2
AStream1210

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 Lebih banyak

$300 USD dalam 3 hari
(1 Ulasan)
2.4
vinodk132

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 Lebih banyak

$250 USD dalam 2 hari
(2 Ulasan)
2.3
azizayoubi

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 Lebih banyak

$250 USD dalam 2 hari
(3 Ulasan)
1.2
srisubra

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 Lebih banyak

$300 USD dalam 4 hari
(1 Ulasan)
0.5
$555 USD dalam 10 hari
(0 Ulasan)
0.0
macrograph

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 Lebih banyak

$250 USD dalam 2 hari
(0 Ulasan)
0.0
latifoglu80

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 Lebih banyak

$250 USD dalam 7 hari
(0 Ulasan)
0.0
chrisbonsu

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

$556 USD dalam 10 hari
(0 Ulasan)
0.0
Liightz

I am expert in PPT making.

$333 USD dalam 10 hari
(0 Ulasan)
0.0
sauthak

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 Lebih banyak

$250 USD dalam 3 hari
(0 Ulasan)
0.0