Create a simple Powerpoint Add-in with VBA and XML (~5 hour project) -- 2
Budget: £20 – £250 GBP
We need to create a simple add-in for PowerPoint that will work as a front-end to an existing back-end model.
Interface part of the add-in:
1. One big button on the "Home" pane of PowerPoint. The title of the button is “Launch model”
2. When a user clicks on the button, a side pane is opened.
3. The side pane has the title “Output of the model” and a scrollable list of 10 images.
4. User can select one of the images and then press the button “Process” which is located at the bottom of the side pane.
Please find a screenshot of the vision of the interface attached.
The technical part of the add-in (it will involve saving and opening files from folders – this is the way the add-in will interact with the back-end model)
1. User clicks the “Launch model button”
2. The add-in saves metadata about the current selected slide in a separate folder (please make the folder path customizable)
a. Metadata has to include slide size and list of the slide elements with:
- IDs
- types (the type can have text format like “Picture” or a numeric format)
- coordinates (x, y, height, width - given upper left corner as the starting point)
- length of text in symbols (0 or null if the object does not have text)
b. If the slide has grouped objects, then they have to be fully ungrouped
c. The metadata can be saved in any readable format: txt, json, csv, etc.
3. Add-in waits for 3 seconds (time need for the back-end model to process the metadata)
4. Add-in opens 10 images from a separate folder (please make the folder path customizable in code) and shows them in the side pane
5. User selects one of the images and clicks the button “Process”
6. Add-in saves the name of the selected image in a separate folder (please make the folder path customizable in code) in any readable format: txt, json, csv, etc.
7. Add-in waits for 3 seconds (time need for the back-end model to process)
8. Add-in inserts the first slide from a separate presentation (the presentation has a fixed defined path) into the current presentation as the next slide after the selected one
Would be great if you could code the add-in using mainly XML and VBA. Please add comments to code to indicate where each of the technical steps is executed.
Thank you!
Interface part of the add-in:
1. One big button on the "Home" pane of PowerPoint. The title of the button is “Launch model”
2. When a user clicks on the button, a side pane is opened.
3. The side pane has the title “Output of the model” and a scrollable list of 10 images.
4. User can select one of the images and then press the button “Process” which is located at the bottom of the side pane.
Please find a screenshot of the vision of the interface attached.
The technical part of the add-in (it will involve saving and opening files from folders – this is the way the add-in will interact with the back-end model)
1. User clicks the “Launch model button”
2. The add-in saves metadata about the current selected slide in a separate folder (please make the folder path customizable)
a. Metadata has to include slide size and list of the slide elements with:
- IDs
- types (the type can have text format like “Picture” or a numeric format)
- coordinates (x, y, height, width - given upper left corner as the starting point)
- length of text in symbols (0 or null if the object does not have text)
b. If the slide has grouped objects, then they have to be fully ungrouped
c. The metadata can be saved in any readable format: txt, json, csv, etc.
3. Add-in waits for 3 seconds (time need for the back-end model to process the metadata)
4. Add-in opens 10 images from a separate folder (please make the folder path customizable in code) and shows them in the side pane
5. User selects one of the images and clicks the button “Process”
6. Add-in saves the name of the selected image in a separate folder (please make the folder path customizable in code) in any readable format: txt, json, csv, etc.
7. Add-in waits for 3 seconds (time need for the back-end model to process)
8. Add-in inserts the first slide from a separate presentation (the presentation has a fixed defined path) into the current presentation as the next slide after the selected one
Would be great if you could code the add-in using mainly XML and VBA. Please add comments to code to indicate where each of the technical steps is executed.
Thank you!