Closed

PowerPoint Automation

I need to automate updating of Charts in a PowerPoint presentation. These graphs will always be the same format requiring only update of the underlying data contained in the Chart Datasheet.

Requirement:

Through use of a VB6 program, automate the transfer of data contained in an external Excel Workbook into the pre-existing PowerPoint Graph.

Example Situation (see attached PP file):

PowerPoint slide deck containing the following:

Slide 1. Cover sheet

Slide 2. Agenda

Slide 3. Sales this Quarter

Slide 4. General text

Slide 5. Personnel Turnover this Year

The following are available as spreadsheet data that needs to be updated in the PP deck:

[url removed, login to view]

[url removed, login to view]

Using the above as an example, the Tool will need to be able to

1. Present a file dialog so user can open the .XLS file,

2. Presnet a file dialog so user can ppen the PP Presentation,

4. Action button to initiate transfer of data to PP.

4. Move the .XLS data to the appropriate Chart in the deck.

5. Close all files and inform user the action is complete.

NOTE: The graphs will always be located as the same slide number and the data format in the .XLS files will always be the same. However, the .XLS files will vary in number of ROWS.

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Fully documented code.

## Platform

Windows 2000

Skills: Engineering, Excel, Microsoft Access, Microsoft Exchange, MySQL, PHP, Powerpoint, Software Architecture, Software Testing, Visual Basic, Word

See more: work powerpoint, use of graph, powerpoint update, powerpoint cover slide, personnel source, example of cover sheet, example cover sheet, cover slide powerpoint, cover sheet example, deck presentation, work excel powerpoint, windows automation, using powerpoint, transfer data into an excel sheet, slide powerpoint presentation, slide deck, powerpoint work, powerpoint graphs, powerpoint 16, complete excel datasheet, automation tool, automation program, excel data automation, php powerpoint text, visual slide deck

About the Employer:
( 9 reviews ) Prairie Village, United States

Project ID: #3048059

5 freelancers are bidding on average $67 for this job

icodeinvb

See private message.

$25.5 USD in 10 days
(316 Reviews)
7.1
prasanna123

See private message.

$63.75 USD in 10 days
(58 Reviews)
5.1
RGATRAC

See private message.

$42.5 USD in 10 days
(11 Reviews)
3.6
maximen

See private message.

$34 USD in 10 days
(0 Reviews)
0.0
sharmisthavw

See private message.

$170 USD in 10 days
(0 Reviews)
0.0